SUMX wrong totals

[Anonymous]

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 fields in one sales table

I want to calculate price variance 

(current year sales/ quantity -previous year sales/quantity) * current year quantitiy. but able to see with all the attributes.. 

if there are no sales for current or previous year on a particular material it has to be 0 otherwise above formula.

below

Price Variance =

if([Sales per Unit_CY]=0 || [Sales per Unit_PY]=0,0,

   CALCULATE(SUMX(VALUES(ATC[material]),[Sales_Per_unit_var]*[Quantity_CY]),ALLSELECTED(ATC[customer])))

[Anonymous]

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])))

[Anonymous]

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])))

[Anonymous]

my table values are customer no, material no,  sales amount, Quantity ,year month.
calculation require :

if the sales current year or sales previous year sales is nill  then 0 if not
==sales per unit variance( current sales /quantity - previous year sales /quantity) * quantity cy 

[Ashish_Mathur]

Hi,

Share some data, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[Anonymous]

[Wilson_]

Hi giri,

Please check the pinned thread in the forum to learn how to provide sufficient details to get your question answered. 🙂