The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Also discussed in https://community.powerbi.com/t5/Desktop/Is-this-a-bug/m-p/1088129#M503956
Reproduction steps:
Create the following table:
FilterColumn | MeasureColumn |
1 | 0 |
1 | 0 |
2 | 0 |
2 | 1 |
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.
Part 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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @MrGorkajuice
This is as designed - we've updated the docs to clarify it :
https://docs.microsoft.com/en-us/dax/all-function-dax