Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

distinct count question

Hello Community,    I have a situation where I need to count the distinct count of "problem codes" against their corresponding order.     The table below perfectly illustrates the issue I am tryi...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, 

    Please correct me if I understood wrongly, but I think you can try the below.

     

    Count of Header Problem Code =
    If ( isfiltered(RMA),

         distinctcount(Header Problem Code),

         [Count of RMA] )

     

    I am not sure if I mentioned column names correctly.

    If it is possible to share your pbix file, it will be much helpful for me to look into it more deeply.

     

    Thanks.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, 

Please correct me if I understood wrongly, but I think you can try the below.

 

Count of Header Problem Code =
If ( isfiltered(RMA),

     distinctcount(Header Problem Code),

     [Count of RMA] )

 

I am not sure if I mentioned column names correctly.

If it is possible to share your pbix file, it will be much helpful for me to look into it more deeply.

 

Thanks.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

That worked perfectly.   Here is the final code and picture of the solution. 

Thanks!

 

Distinct Count of Header Problem Code =
IF( ( ISFILTERED(Merge1[RMA]),
DISTINCTCOUNT(Merge1[Header Problem Code]),
[Distinct Count of RMAs] )

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    That's great. I am glad that I could help.

    I hope you have a great weekend. ðŸ˜€