Forum Discussion

MichaelaMul's avatar
MichaelaMul
Helper III
1 year ago

Using Percentile.Inc in a Gauge Visual

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!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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