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.
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.