Forum Discussion
Switch Measure in Matrix with multiple columns
- 2 years ago
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.
- 2 years ago
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 - 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 below
a. 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