Forum Discussion
Cannot include value in waterfall chart.
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
[email protected]:Adityadambal/PowerBI.git
Hi Anonymous
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!!
1 Reply
Hi Anonymous
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!!