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)))   ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    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

DHB's avatar
DHB
Helper V
6 years ago

Thanks Pat, that works but I have another issue now.  I'm representing that measure in a gauge visual and when I apply filters in the report the value stays at 100%.  With the DAX I used before it only showed 60% but when I used filters this would go up and down between 0-60.  Can I use the ALLSELECTED version and still have the gauge correspond to the filters I use somehow?

amitchandak's avatar
amitchandak
Super User
6 years ago

DHB , try like

DIVIDE(calculate([COUNT(ACTIVITY[PERSON_CODE]),FILTER(ACTIVITY,ACTIVITY[YEAR]=2019&(ACTIVITY[ENROL_WF]="active"))),CALCULATE(COUNT(ACTIVITY[PERSON_CODE]),ALL(ACTIVITY)))