Forum Discussion
Slicer Filter Misbehaving
Hi ajaybabuinturi,
Thank you so much for your quick reply! I tried using the above, but all it did was filter out every value for some reason.
But your suggestion gave me some ideas. I need to go through my Report more carefully and check the filter interactions. That is probably my problem.
Sorry for the late response. It turns out my interactions were the problem. Once I went through each one I was able to resolve the error.
Regrettably, my report is dizzyingly complex. But, I am happy to report that it is working properly now.
Hi WishAskedSooner ,
Thank you for reaching out to the Microsoft Fabric Community Forum, and great to hear you're actively troubleshooting this.
The DAX shared by ajaybabuinturi is correct using REMOVEFILTERS('dimSlicerTable') ensures [MyMeasure] is evaluated independently of the slicer’s row context, which is essential in this scenario.
If applying this logic results in all values being filtered out, it's likely due to additional filter interactions within your report. We recommend checking whether slicers A–E or any page/report-level filters are indirectly impacting 'dimSlicerTable' or [MyMeasure].
Also, review your data model for any active relationships that could be contributing to this behavior. As a quick check, try placing [MyMeasure] in a card next to a table of 'dimSlicerTable'[Slicer_F_Values] to observe how the values interact across rows.
Hope this helps. Please reach out for further assistance.
Thank you.