I have a report that look like this:
Problem is the Measure (Issues created). I have a dimension custumor and the relation between Issues and customers is n to 1. So it is possible to have 8 issues created for 1 customer.
I now need to report on a group by on customer, so my measure isn’t “Issues created”, but “unique customers”.
e.g now it says for in production in 2019 “8”, but it are only 3 unique customers, so I should have 3.
I have a calculated field “Issue_Customer”
But with this I only have empty fields.
I tried following syntax:
but this doesn’t work. Anyone out here that knows the right solution?