Forum Discussion

DHB's avatar
DHB
Helper V
6 years ago
Solved

Use Filters in Measure DAX

I have a list a set of data which I've used this DAX to calculate percentages of the total records;   DIVIDE(COUNT(ACTIVITY[PERSON_CODE]),CALCULATE(COUNT(ACTIVITY[PERSON_CODE]),ALL(ACTIVITY)))   ...
  • mahoneypat's avatar
    6 years ago

    I would first try your original measure with ALLSELECTED() instead of ALL().

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi DHB ,

     

    You may try to use the below measure:

    DIVIDE(COUNT(ACTIVITY[PERSON_CODE]),CALCULATE(COUNT(ACTIVITY[PERSON_CODE]),ALLSELECTED(ACTIVITY)))

     Please try.

    Aiolos Zhao