Waterfall chart with multiple measures

Hi, IF 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

Test:

There is no relationship between two tables: You may create measures as below.

A Measure = SUM('Table'[A])

R_DM Measure = SUM('Table'[R_DM])

R_Nego Measure = SUM('Table'[R_Nego])

R_Pjt Measure = SUM('Table'[R_Pjt])

Result = 
SWITCH(
    SELECTEDVALUE(Test[MeasureName]),
    "A",[A Measure],
    "R_DM",[R_DM Measure],
    "R_Nego",[R_Nego Measure],
    "R_Pjt",[R_Pjt Measure],
    BLANK()
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, IF 

You may go to 'Query Editor', click 'Add Columns'=>'Index Column' to create an index column and then 'Close and Apply'.

Then you need to make the column 'MeasureName' selected, click 'Sort by column'=>'Index'.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.