Forum Discussion
Solved
Filter not Filtering
I have a workbook with a slicer and 3 measures in it. I cannot share the real data, but it looks like this: KatA KatB Count Value Department 1 X 1 100 A 1 Y 1 200 A 0 X ...
Hi H3nning
Why is KatB using a different switch table? Also, I would use SELECTEDVALUE instead of VALUES as the latter returns a table instead of a scalar value - no problem if there is only one selection but will return an error if not. These aside, I can't replicate your issue. Your measure should work as intended.
Hi H3nning
Use a numeric flag column or explicit boolean logic:
CALCULATE(
SUM('Table'[Value]),
'Table'[_KatB] = 1
)
For reliable slicer interaction, prefer numeric calculated columns or boolean flags over text comparisons inside measures.
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Regards,
Rufyda Rahma | MIE