Forum Discussion
H3nning
Helper V
9 months agoFilter 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 ...
- 9 months ago
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.
V-yubandi-msft
Community Support
9 months agoHi H3nning ,
If you have the opportunity to review danextian response, you'll see that it meets your requirements. Please review it and let us know if you need any additional assistance.
Thank you danextian for your helpful input.