Cannot include value in waterfall chart.

[adambal]

Hi All,

I am creating a waterfall chart with measures aggrigated in a table. One particular measure is outputting 'null' when I present it in a matrix or waterfall chart. But, when I check its value on a card, it shows 74k as it is expected to. I have also attached a .pbix file with the issue on the last tab.

Could someone let me know what the issue might be?

Thanks

git@github.com:Adityadambal/PowerBI.git

[Jayee · Accepted solution]

Hi @adambal 

Use below DAX its give you expected Result

Result =
SWITCH (
SELECTEDVALUE ( 'TableA'[Merged] ),
"LDPE Purchased Quantity", [WC LDPE Purchased Quantity],
"Act Inv", CALCULATE ( [Actual Inv], ALL ( TableA ) ),
"LLDPE Purchased Quantity", [WC LLDPE Purchased Quantity],
"HDPE Purchased Quantity", [WC HDPE Purchased Quantity],
"Specialities Quantity", [WC Specialities Quantity],
"HDPE Plastics Manufactured Quantity", [WC HDPE Plastics Manufactured Quantity],
"HDPE Resins Quantity", [WC HDPE Resins Quantity],
"LDPE Botany Manufactured Quantity", [WC LDPE Botany Manufactured Quantity],
"HDPE Botany Manufactured Quantity", [WC HDPE Botany Manufactured Quantity],
"LLDPE Botany Manufactured Quantity", [WC LLDPE Botany Manufactured Quantity],
"Ethylene Altona Quantity", [WC Ethylene Altona Quantity],
"Ethylene Botany Inc imports Quantity", [WC Ethylene Botany Inc imports Quantity],
BLANK ()
)

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!