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
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.