Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Wrong Totals

Hi

I am a beginner in Power Bi and having a hard time getting my totals right.

Wrong column totals need to be corrected as I want to use this corrected total to multiply with an average cost

 

Data:

 

Measures:

 

 

Shipments Saved = DIVIDE([Volume],CALCULATE([Loadability volumetric],DATEADD(dDate[Date],-1,MONTH)),BLANK())
Shipments Saved WRONG = 
SUMX(
SUMMARIZE(dDate,dDate[Date],"_1",
          DIVIDE([Volume],CALCULATE([Loadability volumetric],DATEADD(dDate[Date],
-1,MONTH)),BLANK()
)
),[_1]
)
Volume = SUMX('Prototype Modeling_Freight', 'Prototype Modeling_Freight'[Sold Cases])
Loadability volumetric = DIVIDE([Volume],[Shipments],BLANK())

 

 

 

  • Hi Anonymous ,

     

    Can you provide me some sample data for testing? Your measure seems OK and I cant figure out where the problem is by your pic and measure .

     

    Much appreciated.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

3 Replies