Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
4 years ago
Solved

unique values are wrong

Hello,   I have a table that counts CASEID (Revenue Accounts)  and then performs a CountDistinct Case ID (Unique Accounts).  However, it is completely wrong when showing a matrix by month.   The ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi lcasey ,

     

    Based on your description, I have built a simple data sample:

     

    Please try:

    Measure = CALCULATE(DISTINCTCOUNT('Table'[Case ID]),ALLEXCEPT('Table','Table'[Month]))

    Here is the final output:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lcasey ,

 

Based on your description, I have built a simple data sample:

 

Please try:

Measure = CALCULATE(DISTINCTCOUNT('Table'[Case ID]),ALLEXCEPT('Table','Table'[Month]))

Here is the final output:

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.