Forum Discussion
Need Help with Dax function
Hi all,
I have created a measure with the following formular:
Activity with one Resp = 100*CALCULATE(DISTINCTCOUNT(L3_ACT_ROLE_RASIC[ProcessLevel3Activity]),L3_ACT_ROLE_RASIC[ProcessLevel3ActivityRoleRASIC]="R")/[Activity Count Role]
When i select multiple values with the slicer I get this tabel visual:
When i select multiple values with the slicer I get this tabel visual:
Now I want a new measure which returns the number of times one of those old measures is greater than 95. With the selection above it should return 3. How would I do this? Can I use the old measure for that?
The underlying table has this form:
Many Thanks in advance!
P
No RepliesBe the first to reply