Forum Discussion
Selecting multiple measures with one field parameter selection
Hello community, I am trying to create a field parameter where two measures are added with one selection. I have no idea if this is actually possible. Something along the lines of this: Be...
Dont know if this is actual anymore, but in case someone searches for it: You can do that "old fashioned". Before there were field parameters this was done by an additional table. You crate a table with your selections in it, just one column. For a Table NewTable example:
| Measure |
| A |
| B |
Now you put Measure in a slicer. From there you can add as many dependent measures as you link. For Example:
SUM=
SWITCH(
VALUES(NewTable[Measure]), "A", SUM(ColumnX),"B",SUM(ColumnY)
)
AVG=
SWITCH(
VALUES(NewTable[Measure]), "A", AVERAGE(ColumnX),"B",AVERAGE(ColumnY)
)
You have to fill in NewTable, Measure, ColumnX and ColumnY as in your example.