Forum Discussion
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 t...
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