Forum Discussion

warnera's avatar
warnera
Helper I
6 years ago
Solved

Distinct total based on another column

Hello, I have a data set like this. I am trying to get a distinct count of the medication per MRN. The medication may repeat for the MRN but I would only like to count it once.   MRN    Medication ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi warnera ,

     

    Apart from Solution mentioned abovem you can try

     

    Count = CountROWS(SUMMARIZE('Table','Table'[Medication],'Table'[MRN ]))
     

     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

rubinboer's avatar
rubinboer
Resolver II
6 years ago

a normal table can visualize the data as it is, should you not need the count in other calculations. Add a table to the canvas drop the Medicine column in it first and then add th distinct count of the MRN. rename the Count of MRN to MRN. a quick ways if all you want is the visualization.