Filtering Matrix table through slicer built on different measures

[Anonymous]

Hi there,

For one dashboard, I am trying to filter matrix table from a slicer consisting of different measures created as shown in the below image.

Slicer part - Have created a table named measure wherein I have entered the name of measures, I wish to use in the slicer and the MeasureMix2 measure is   has been used in the bar chart on the left side to show the yearly value for the selection done in slicer

Now, I want to link the matrix table on the right side with other measures (calculating the first & third quartile, Mean & median of basically the same column from which the measure calculation is been done

Is there any way to achieve it?

Thanks

Saket

[Anonymous · Accepted solution]

@Anonymous 

It is hard to say without seeing the model, measures are based on the table columns, if you have correct relationships settled, no additional expression is required. 

For your dax, try create a new table for the slicer values. 

Then try something like following:

measure = Switch(selectedvalue(newtable[slicer column]),

"SG&A as % ...." , [SG&A Median],
"EBIT conribution ......", [EBIT per SG&A spend]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[VijayP]

@Anonymous 

Instead of using ISCROSSFILTERED, use SelectedValue and it may help and let me know whether that works!