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...
they are not helpful, its simple by totals not adding up . I think its context transition issue.
values are correct , but total of correct values not correct .
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])))