Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Inconsistent behavior when Measure is used as a filter in Matrix Visual

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.

1 Reply

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion

    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