Forum Discussion
Dynamic measure filtering
Hi powerlight1,
Thank you for explaining your requirement so clearly and also for providing the sample data. I tried the same scenario in Power BI and your logic is absolutely right. The only final step you were missing was after creating your IsInSelectedBand measure, you need to select the table visual (which shows product and average sales), and then drag IsInSelectedBand into the "Filters on this visual" pane, and set it to 1.
Once this is done, the table will only show those products whose average sales fall into the selected band, based on the state and date filters you applied in slicers. I tested with your values and it’s working exactly as expected.
Please find the attached pbix file for your reference.
Thanks again for the nice scenario!
Hi powerlight1,
Thank you for explaining your requirement so clearly and also for providing the sample data. I tried the same scenario in Power BI and your logic is absolutely right. The only final step you were missing was after creating your IsInSelectedBand measure, you need to select the table visual (which shows product and average sales), and then drag IsInSelectedBand into the "Filters on this visual" pane, and set it to 1.
Once this is done, the table will only show those products whose average sales fall into the selected band, based on the state and date filters you applied in slicers. I tested with your values and it’s working exactly as expected.
Please find the attached pbix file for your reference.
Thanks again for the nice scenario!
Hi powerlight1 ,
Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Thank you.
Perfect! Thanks again.
