Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to use a simple measure as a filter on my visuals. This measure works fine as a filter on Table visualization and also on Matrix visualization when any attribute from Date table is selected at Row level. But it doesn’t work in Matrix visualization when any attribute from Date table is selected at column level.
Please refer Model diagram and DAX code for your reference ..
Consol Status - Measure =
SELECTEDVALUE('Entity Consol Status'[Consol Status ])
Image with Measure Values (no filter applied) in Matrix format:
Not working when Filter on Consol Measure is applied (when Quarter is in column - Matrix Format):
Working fine when Filter on Consol Measure is applied (when Quarter is in Row - Matrix Format) and
also when Filter on Consol Measure is applied in Table Format.
Hi @Anonymous can you share your pbix with sensitive data scrubbed? It's hard to figure out what the trouble is based on your description.
David
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |