I am struggling with a measure. It seems like the SUMX does not accept conditions based on a calculated measure.
Hence, my challenge is on the conditional part of the SUMX.
Has anyone experienced the same?
Any suggestions on how to solve it?
I guess the problem is the if_ expression try this:
Volume Effect =
VAR Tab = SUMMARIZE('Sales Order Details',Customer[Customer ID],'Product'[Product ID])
Var if_= IF([Avg Sales Price]=0 || [Avg Sales Price LY]=0,[Sales Growth], ([Quantity]-[Quantity LY])*[Avg Sales Price LY])
RETURN SUMX(Tab, if_)
Yes, I figured the problem is on the IF expression. However, your solution does not work either. It is like the condition is not evaluated at all...
Regardless if the [Avg Sales Price] or the [Avg Sales Price LY] are 0 or blank, it does not accept the condition and returns me 0 instead of [Sales Growth].
You should look at the [Avg Sales Price] and [Avg Sales Price LY] measures, can you show us the formulas for the 2 measures.
Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.