Forum Discussion

Peter_K's avatar
Peter_K
New Member
2 years ago
Solved

Countrows if ID is unique

Hello. I have browsed your solutions here, but coudn't find anything i could use in my situation. I am all new to PowerBI. I have a JSON datasource, with 500 chats in it. It has following columns: ...
Need Help
  • Irwan's avatar
    Irwan
    2 years ago

    Hello Peter_K 

     

    please check if this accomodate your need.

     

    I made a random data based on your problem.

     

    Create a measure with following DAX:

    Count =
    var _Message = SELECTEDVALUE('Table'[Message])
    Return
    CALCULATE(DISTINCTCOUNT('Table'[ChatID]),FILTER('Table','Table'[Message]=_Message))
     
    If this result doesnt match to your problem, please give a set of dummy data that can represent your whole data.
     
    Hope this will help you.
    Thank you.
  • Irwan's avatar
    Irwan
    2 years ago

    Hello Peter_K ,

     

    that happens because of the filter in calculate DAX. The total seems not be able to be calculated properly.

     

    In my sample data, the total didnt even show up.

     

    To solve this, simply just remove the filter and use DISTINCTCOUNT directly

     

    In fact, if your data has uniqueID for every message, I think direct distinctcount should do the job (no need put any filter by calculate DAX).

    But please give it a try first and let see if you get the correct value or not by using direct distinctcount.

     

    Hope this will help you.

    Thank you.

Peter_K's avatar
Peter_K
New Member
2 years ago

I can't clean the JSON file for GDPR content.
The file has confidental data.
Does that mean you cant help me?