Forum Discussion
Discrepancy in Dual-Visual Comparison (Peer Analysis) despite identical Slicer selections
Scenario: I have a Power BI report designed for financial peer comparison (CSM Amortization). The report is split into two identical sections (Top and Bottom) to allow users to compare two...
Update on the issue: I've discovered that the discrepancy disappears when I disable "Single Select" and turn off "Force Selection" on the slicer (a toggle between "Health" and "LTS").
When "Single Select" is ON, the bottom visual displays incorrect totals. When I allow multiple selections (even if only one is practically selected) or use a regular slicer, the values align perfectly.
It seems like the ALLSELECTED function in my DAX measure is interacting poorly with the Required Single Selection state of the slicer, causing a filter context conflict in the cumulative calculation