Forum Discussion

afelber's avatar
afelber
Frequent Visitor
9 years ago

ALL Function Not Working

Hello,   I am trying to create a a measure to use in a graph that is not impacted by a slicer filter called 'listing number' on the report. The measure I created is as follows:   25th Percentile ...
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi afelber,

 

Please don't use ALL() function,

 

25th Percentile Number Bookings = CALCULATE(PERCENTILE.INC('Metrics by Listing'[Number of Bookings Listing], 0.25),FILTER('Metrics by Listing','Metrics by Listing'[Owner]<=10 && 'Metrics by Listing'[Hidden]=0 && 'Metrics by Listing'[StartMiddle]=0))

 

Then select the slicer visual, enable Edit Interactions, click the NONE for chart. See: Visualization interactions in a Power BI report.

 

 

 

Best Regards,
Qiuyun Yu

afelber's avatar
afelber
Frequent Visitor
9 years ago

Thanks Qiuyun. I have used this interaction functionality before however it does not work for what I need because I need one line in the graph to respond to the slicer. 

 

I will provide a bit more detail on what I am trying to accomplish. Suppose I have a table that has a four colunms: unique ID, city of the ID, state of the ID, month, and sum of revenue for that unique ID in the month. 

 

I want to create a line graph where the x-axis is month and y-axis is sum of revenue with 2 lines in the same graph. One line should only show the sum of revenue by month for a specific ID selected in the slicer and the other should show the 25th percentile of revenue for all IDs (i.e. ignore the slicer) so that a user can compare that values for the specific ID to the 25th percentile. I also need to be able to filter the 25th percentile by a city slicer and state slicer. Is it not possible to build the 25th percentile measure to accomplish this?