Forum Discussion
Incorrect Measure Row Total using CALCULATE SUMX
Maricon , [Total Sales Qty] is the measure, does it belong to Data_Ship?
if not then force a row context
Total Sales LP = CALCULATE(sumx(values(Data_Ship[Actual ship date]),[Total Sales Qty]*Data_Ship[SalesLP]))
This need to some level where multiplication should be correct, not [Actual ship date]
See row context play a role here : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
Maricon , [Total Sales Qty] is the measure, does it belong to Data_Ship?
if not then force a row context
Total Sales LP = CALCULATE(sumx(values(Data_Ship[Actual ship date]),[Total Sales Qty]*Data_Ship[SalesLP]))
This need to some level where multiplication should be correct, not [Actual ship date]
See row context play a role here : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
amitchandakThank you so much. Looks like it works, Let me try also to my other files. Thank you again!