Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

dax/visuals help

Hi all,

 

I have this measure to calculate a percentage:

Perc=

DIVIDE(
CALCULATE(
    COUNTA('fact taskResults'[TaskKey]);
    'fact taskResults'[Result_did] IN { 6 }
)
;
COUNT('fact taskResults'[TaskKey]))
 
I have a column TaskTypes that group some tasks of the same type, and now I need to show how much of these Types have a "Perc" bigger than ex: 50%. ex: 25 of 30 have a percentage above 50% (on a Gauge)
But i can't figure out how...
 
Thanks.