cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adambal
Helper III
Helper III

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

 

adambal_0-1668651217091.png

 

 

 

git@github.com:Adityadambal/PowerBI.git

1 ACCEPTED SOLUTION
Jayee
Responsive Resident
Responsive Resident

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 ()
)

 

Jayee_0-1668653723966.png

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

 

View solution in original post

1 REPLY 1
Jayee
Responsive Resident
Responsive Resident

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 ()
)

 

Jayee_0-1668653723966.png

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

 

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors