Measure to Filter matrixvisual by Multifilter

[Anonymous]

Hi,

in my matrix-visual "Multifilter" (right) filters according to "Versicherungsprodukte" (top) - but nevertheless other columns still appear, even if they do not have Results:

How do I make the rows for the other columns (containing names, logo, do-they-have-special-products/leafs) disappear?

At the top of my head I think I need to create a measure for the rows:

IF (

SELECTED ( ( FaktMultifilter[VALUE] ) IN {"Nachhaltige Haftpflicht", "Nachhaltige Hausrat",...}", (FaktStruktur[Basisinfo:Versicherer] ) ) )

and some other measures for the matrix visuals' values:

IF (

SELECTED ( ( FaktMultifilter[VALUE] ) IN {"Nachhaltige Haftpflicht", "Nachhaltige Hausrat",...}", (FaktStruktur[Basisinfo:Logo] ) )

)

But is there an easier way I simply don't know?

 

 

[v-xiaotang]

Hi @Anonymous 

here are 2 ways for your reference,

(1) change the setting of the visual-level filter,

(2) Or you can change the measure, add a judgment statement to measure  (see below)

Don't forget to uncheck this option: show items with no data.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @lbendlin ,

unfortunately it's already unchecked.

I've noticed: The behaviour only occurs if I drop a measure to values. Once I've made a custom column out of it and dropped this in, everything was fine.

[lbendlin]

In the rows section of your visual use a dropdown next to one of the fields and uncheck "Show items with no data"