Forum Discussion
Diffrence in unique values in table and in summarized total
Hey, For one of my data models I'm finding a difference in the unique values within a table. I want to know the number of unique customers that has a subscription and when this subscription i...
Anonymous , The formula I suggested will force a total of rows.
Simple DISTINCTCOUNT (Table[customer id]), will be recalculated at grand total and subtotal level
Anonymous
Try use Hasonevalue(), something like:Measure = IF(HASONEVALUE(Table[customer id]),DISTINCTCOUNT(Table[custome id]), calculate(DISTINCTCOUNT (Table[customer id]), all(table))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserAnonymous , You have to create a measure like this
sumx(values(Table[Month year]), calculate(DISTINCTCOUNT (Table[customer id])))
Hi amitchandak I've tried this solution and it seems right but now the total of the table are corresponding with the total of the values in each of the rows. Is this a normal result? And is there a work around for this?
- amitchandak
Anonymous , The formula I suggested will force a total of rows.
Simple DISTINCTCOUNT (Table[customer id]), will be recalculated at grand total and subtotal level