Show the same amount of filtered values ​​for all rows

[washrodrigues]

Hey Guys!

I'm trying to create a behavior where I can check how many values have been filtered and then change the measure behavior.

It works when I'm using SELECTEDVALUE, but as the value in the filter comes from the same dimension that I'm using in the table rows, then for each row the function is showing kind of just one value selected, just in the total row, it shows multiple values selected.

I'd like to have "multi" in all rows.

Is it possible to change this behavior? 

[washrodrigues]

That's perfect! Thank you so much!

[NaveenGandhi · Accepted solution]

Hi @washrodrigues 

It would be better if you share some sample data along with expected outpt as screenshot to understand the problem better.

But see if below measure helps.

Selected =

VAR __selected =

    CALCULATE (

        DISTINCTCOUNT ( 'Table'[Category] ),

        ALLSELECTED ( 'Table'[Category], 'Table'[Production class] )

    )

RETURN

    SWITCH ( TRUE (), __selected > 1, "multi", SELECTEDVALUE ( 'Table'[Category] ) )

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!