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
Solved! Go to 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!!
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!!
User | Count |
---|---|
137 | |
60 | |
59 | |
55 | |
47 |
User | Count |
---|---|
130 | |
78 | |
55 | |
54 | |
52 |