Percentage Compliance

[Hgsilva]

I have a number value column and need to figure out how to show how many of these values are at 720 or below. How do I figure out the percentage of values that are 720 or below? Also what would be the best visualization to display the amount of values below 720?

[FreemanZ · Accepted solution]

hi @Hgsilva ,

try to plot a guage visual with a measure like:

Pct =

DIVIDE(

    COUNTROWS(

        FILTER(

            data,

            data[value]<=720

       )

    ),

    COUNTROWS(data)

)

more about guage visual:

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts?tabs=p...

[Hgsilva]

Thank you very much @FreemanZ This was very useful!