Forum Discussion
SUMX wrong totals
HI when I export data, totals are different to what i am getting in Power bi dashboard please help me with the following problem. I have customer, material , segmant, sales, quantitiy all the fiel...
sales has to be calculated to material level hence I have used
Price Variance =
if([Sales per Unit_CY]=0 || [Sales per Unit_PY]=0,0,
CALCULATE(SUMX(VALUES(ATC[material_style1]),[Sales_Per_unit_var]*[Quantity_CY]),ALLSELECTED(ATC[top_level_account])))