Filtering a matrix visual by measures

[Anonymous]

I am trying to filter a matrix visual by the measures within that visual. Here is what the matrix currently looks like: matrix

Each of the matrix values are individual measures. I would like to be able to filter this matrix such that only selected values show up, so for example I could select only 'Ttl Case Qty' and under each month only the values and the column for 'Ttl Case Qty' would show up, and not the values and columns for the other measures. I can't put a measure on a filter visual since Power BI does not allow it. I have tried putting this measure

MonthlyElementSelect = SWITCH(
    SELECTEDVALUE(s_MonthlyElementSelection[Index]),
    1, [Ttl Case Qty],
    2, [Gross Sales less POD's],
    3, [GP%],
    4, [Material Margin %],
    BLANK()
)

into a column in this table to try and visually create a filter as a kind of workaround (see here, second post from top; the original method just creates the measure and puts it on a waterfall, but here I'm trying to create a column with that same measure and putting that column on a filter visual) but no values are showing up in this column, so this does not appear to be the right approach. Any help would be very appreciated!

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

If you want to display  the values of one measure in matrix by default, it will be implemented.  I modify the formula you can reference.  However if to display the values of all the measures, I’m afraid it will not be implemented.

Measure 2 =
    SWITCH (
        SELECTEDVALUE ( Table2[Index] ),
        1, [Ttl],
        2, [POD],
        3, [GP],
        [Ttl]
    )
you can change the default measure of Ttl to what you want.

Best Regards,

Xue Ding 

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

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue

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