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,

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.