Forum Discussion
Filtering Matrix table through slicer built on different measures
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
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.
2 Replies
Anonymous
Instead of using ISCROSSFILTERED, use SelectedValue and it may help and let me know whether that works!
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.
