Waterfall using Multiple Measures not producing anything (source of Measure is included)

[Anonymous]

HI,

FIRST: I give KUDOS and mark as solved!

I found what looks like a great Waterfall Solution but I can not get it to work. It should work in a simple table with the supporting column PVM_Order[PVM_Waterfall1] (showen in the very bottom snippet).

https://community.powerbi.com/t5/Desktop/Waterfall-chart-with-multiple-measures/m-p/1186499

First, all the measures used in the formula to create a Waterfall work (a snip of a table is below).

Below is my Formula to produce the waterfall.

The PVM_Waterfall formula appears to be doing nothing. I show examples at the bottom of four tables in a report with that Measure coming up Blank.

Any ideas? Thank you for reading!

PVM_Waterfall =

SWITCH(

    SELECTEDVALUE( PVM_Order[PVM_Waterfall1] ) , // Table with Values (Name for Column)

    "1", [Sales_USD_PYTD] , // Fact_Sales table

    "2", [PVM_Price_Impact] , //ProductMix_Measures table

    "3",[PVM_Volume_Impact], // ProductMix_Measures table

    "4",[PVM_MIX_Impact] , // ProductMix_Measures table

    "5" , [Sales_USD_YTD],  // Fact_Sales table

    BLANK() )

A table with all the measures: The revenue change produced by the PVM measures matches actual revenue change

PVM_Volume_Impact	PVM_Price_Impact	PVM_Mix_Impact	Revenue_Change_PVM	Sales_USD_YTD_vs_PYTD
(282,689)	108,707	(25,494)	(199,475)	(199,480)
			Rounding

A snippet of four tables in a report showing the PVM_Waterfall producing nothing

[MattAllington · Accepted solution]

You need to change your formula to this

SWITCH(

    SELECTEDVALUE( PVM_Order[Order]