Need Help with Dax function

robewertd — Mon, 10 Jul 2023 08:11:04 GMT

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:

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!

topic Need Help with Dax function in DAX Commands and Tips

Need Help with Dax function