Using Percentile.Inc in a Gauge Visual

[MichaelaMul]

Hi everyone,

I would like to show an item's velocity compared to the 50th percentile volume in a gauge visual but not sure how to do so. I tried to make the measure into a calculated column but the numbers are slightly off for some reason, and when in the gauge visual when you add it as the maximum value, it just says the maximum is the value that you put in as the value, rather than the 50th percentile value.

This is the measure:

Volume velocity 50th percentile = calculate(PERCENTILE.INC(Distribution[Volume per $MM per Item],.5),ALL(Distribution[Product]),Distribution[Average Weekly ACV Distribution]>2.5)

This is the calculated column

vol vel 50th percentile column = calculate(PERCENTILE.INC(Distribution[Volume per $MM per Item],.5),ALL(Distribution[Product]),Distribution[Average Weekly ACV Distribution]>2.5)

Thanks!

[Anonymous]

Hi @MichaelaMul ,

If I understand you wrongly, please provide simple data and show the expected results in a picture.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Regarding your question, for your measure, the filter context only has the 'Time' column. For your calculated column, you only removed the filter effect of the column 'Product', and the filter effects of other columns still exist, so this should be the reason for the different results of your attempts.

In the gauge visual, the column 'Time' is missing as a filter condition. 0.31 is the result based on the entire data set. You need to place an additional slicer and use the column 'Time' as the slicer field.

Best Regards,
Wenbin Zhou