Forum Discussion
Solved
Calculate Total weight and visualize
I would appreciate some help to get the visualization correct. I got some help earlier to calculate percentage, I have used that DAX to try to solve this. What I have Every day I get the results f...
As far as what I understand you are facing issues with totals, I would suggest you to follow this syntax
Total Weight = var _table= ADDCOLUMNS( SUMMARIZE('Orders', 'Orders' [Order nr], 'Orders' [Article nr], 'Orders' [Netto weight g], 'Orders'[Ordered Amount] ), "Weight", ('Orders' [Netto weight g]/1000) * 'Orders'[Ordered Amount]) RETURN SUMX(_table, [Weight])Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
tharunkumarRTK
Super User
Super UserAs far as what I understand you are facing issues with totals, I would suggest you to follow this syntax
Total Weight =
var _table= ADDCOLUMNS( SUMMARIZE('Orders', 'Orders' [Order nr], 'Orders' [Article nr], 'Orders' [Netto weight g], 'Orders'[Ordered Amount] ), "Weight", ('Orders' [Netto weight g]/1000) * 'Orders'[Ordered Amount])
RETURN
SUMX(_table, [Weight])Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Thanks! 👍
I'll try that one as well. I found a solution myself.
