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)

amitchandak's avatar
amitchandak
Super User
6 years ago

warnera , you need to use

distinctcount(Table[MRN]) and view it by Medication