Forum Discussion

shankyy7227's avatar
shankyy7227
Frequent Visitor
8 years ago
Solved

distinct count of multiple columns

My data contains FName, LName, MName, Gender, Card ID, Health ID, Active Flag and there may be Null in any column for each row i am trying to calculate distinct count  (FName+Card ID+Health ID) and d...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Create two measures and try the following Dax

     

    Measure1 = COUNTROWS(GROUPBY(User,User[FNAME],User[Card ID],User[Health ID],User[Gender]))
    Measure2 = COUNTROWS(FILTER(GROUPBY(User,User[FNAME],User[Card ID],User[Health ID],User[Gender]),User[Gender]="M"))

     

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create two measures and try the following Dax

 

Measure1 = COUNTROWS(GROUPBY(User,User[FNAME],User[Card ID],User[Health ID],User[Gender]))
Measure2 = COUNTROWS(FILTER(GROUPBY(User,User[FNAME],User[Card ID],User[Health ID],User[Gender]),User[Gender]="M"))

 

 

 

  • shankyy7227's avatar
    shankyy7227
    Frequent Visitor
    8 years ago

    Thanks Jessica the Measures are working.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Worked for me too.

    Thumbs up