Put multiple measures in one table for waterfall chart

[Anonymous]

Hello community,

Please, I need your help.

I have multiple measures and i want to put all my measures in one table.

N.B: I have three filters applied to these measures.

Thank you so much.

[Anonymous · Accepted solution]

Hello,

Final i resolve this problem, to do this :

1- create a new table with a single column which represents the name of all measures and create a new measure with this syntax :

Value = SWITCH(MAX(Measure_Table[Attribute]);
"NCM US (M$) pour Actual";[NCM US$ pour Actual];
"NCM US (M$) pour Plan"; [NCM US$ pour Plan];
"MP_Diff (M$)"; [MP_Diff (M$)];
"FC_Diff (M$)"; [FC_Diff (M$)];
"FR_Diff (M$)"; [FR_Diff (M$)];
"PP_Diff (M$)"; [PP_Diff (M$)];
"Vol_Diff (M$)"; [Vol_Diff (M$)];
"WC_Diff (M$)"; [WC_Diff (M$)];
"SGA_Diff (M$)"; [SGA_Diff (M$)];
"VC_Diff (M$)"; [VC_Diff (M$)]
)
Finaly we have table with one column and one measures, i do this because i need to represent all my measures in whaterfull chart.

[iplaygod]

I dont know if I understand correctly.

But if you want your measures to grouped together under the same table in the pane to the right, then what you can do is:

1. Click on / select the measure you want to "move"
2. Click "Modeling" in the top menu
3. Look for "Home Table:  <someTableName>" 
   Its a drop down, click it and select the table that you would like the measure to live under
4. Done. that "moves" the measure so that it appears under that newly selected table

[Nathaniel_C]

Hi @Anonymous ,

Please give us more details. Maybe a picture?

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel