dax/visuals help

[Anonymous]

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.

[Anonymous · Accepted solution]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490