Also discussed in https://community.powerbi.com/t5/Desktop/Is-this-a-bug/m-p/1088129#M503956
Create the following table:
Create the following measure:
IgnoreMeasureColumnFilter = CALCULATE(COUNTROWS('Table');ALL('Table'[MeasureColumn]))
Create a Slicer for filtering on FilterColumn (List/Dropdown mode).
Create a Card visual that displays IgnoreMeasureColumnFilter. Assign the basic filter "MeasureColumn is 1" to the Card visual.
When only FilterColumn = 1 is enabled in the slicer, the card visual displays (Blank). Expected value: 2.
Continuing from above, on the FilterColumn slicer created above, enable Show "Select all" option.
Check "Select all" (so the slicer shows that both Select all, 1 and 2 is checked). Card visual shows 4 (expected)
Uncheck "Select all" so all checkboxes are empty. Then check both 1 and 2. Card visual shows 2. Expected: 4 (same as above).
This is as designed - we've updated the docs to clarify it :
I have reported this issue internally: CRI 188210647. Will update here once I get information.
Best Regards,Qiuyun Yu
Thank you for looking into this, even if I was hoping for a slightly different outcome 🙂