Forum Discussion

katemarkoska28's avatar
katemarkoska28
Frequent Visitor
1 year ago
Solved

Using Field Parameters on Columns in matrix

I have this field parameter Switch = { ("Number", NAMEOF('Calculations'[ProductionLastMonth]), 0,"LastMonth",1), ("Value", NAMEOF('Calculations'[ValueProductionLastMonth]), 1,"LastMonth",1), ("Nu...
Need Help
MFelix's avatar
MFelix
Super User
1 year ago

Hi katemarkoska28 ,

 

This is a limitation on the Field Parameters that when you use them in the matrix the values get multiplied by all columns.

 

The option is to create a switch measure to place on the values of the matrix something similar to:

 

Matrix Values=

Switch (
SELECTEDVALUE('Calculations'[Order]),
0, [ProductionLastMonth],
1,[ValueProductionLastMonth],
2, [ProductionCurrentMonth],
3,[ValueProductionCurrentMonth])

Then use the columns for the aggregation on the matrix.