Forum Discussion

AZL's avatar
AZL
Frequent Visitor
7 years ago
Solved

Count Distinct with Data Filtering

Greetings,   Guys, I have the folloiwng problem:   I have the follwoing dataset     and here is the output chart   As you notice for item "B" the count distinct without filtering...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi AZL ,

     

    Please download it from the attachment.

    In [statusNum]>=2, "=2" means there are "Completed" and "Pending" at the same time. ">2" means there could be a third status just in case.

     

     

    Best Regards,

AZL's avatar
AZL
Frequent Visitor
7 years ago

Greetings,

 

v-jiascu-msft 

 

I tried it and i'm getting the following error:

 

"A single value for column 'Status' in table 'table1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

 

I'm trying to understand the script but I couldn't understand why did you use ( [statusNum]>=2),"data" )

 

I will appreciate it if you can attach a power bi file with the script for more explanation.

 

Thank you

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi AZL ,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

  • AZL's avatar
    AZL
    Frequent Visitor
    7 years ago

    v-jiascu-msft 

     

    Sorry....I forgot to update it last time I logged in.

     

    Thank you so much for the solution.