Incorrect Measure Row Total using CALCULATE SUMX

[Maricon]

Hi. Can you help me find out what could be wrong here. I used below to calculate the Total Sales LP, but the result of those highlighted in yellow are not correct. Thank you in advance

Total Sales LP = CALCULATE(sumx(Data_Ship,[Total Sales Qty]*Data_Ship[SalesLP]))

[amitchandak · Accepted solution]

@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-Differ...

[Maricon]

@amitchandakThank you so much. Looks like it works, Let me try also to my other files. Thank you again!