Forum Discussion
Switch Measure in Matrix with multiple columns
Hi Coffee321
It sounds like field parameters, please check the attached link :
https://www.youtube.com/watch?v=V6WchPDZibI&t=3sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Coffee321 - This can be done by following approach
1. We have to create table with the values to be listed in the Filter. Dollars, Volume, Per Unit
2. Create 4 Measurements as belowa. Actuals = SWITCH(SELECTEDVALUE('Filter'[Measure]), "Dollars", SUM(Data[Actuals $]), "Volume", SUM(Data[Actuals Vol]), "Per Unit", SUM(Data[Actuals Per Unit]), BLANK())
b. Actuals PP = SWITCH(SELECTEDVALUE('Filter'[Measure]), "Dollars", SUM(Data[Actuals PP $]), "Volume", SUM(Data[Actuals PP Vol]), "Per Unit", SUM(Data[Actuals PP Per Unit]), BLANK())
c. Var = [Actuals] - [Actuals PP]
d. Var % = (ABS([Actuals]) - ABS([Actuals PP])) / ABS(([Actuals]))
In this way, we can achieve your requirement. Let me know if you want more details or any related questions
Hi Coffee321
It sounds like field parameters, please check the attached link :
https://www.youtube.com/watch?v=V6WchPDZibI&t=3s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks. I don't think that will work because I will need 12 different parameters in a slicer and I will be able to only look at one column at a time in the matrix. What I'm after is this:
Slicer with three options:
And that slicer, filtering the matrix like this:
When selecting dollars, all 4 columns (4 measures) will show amounts in dollars
When selecting volume, all 4 columns (measures) will show measures based on volumes:
When selecting Per Unit, all 4 columns will show per unit: