Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
My dax measure is not returning the correct total.
The dax is:
The column on the left has the correct total, and the one on the right the incorrect total.
The measure I use is:
Cost What If =
DIVIDE(
SUM('DB'[Demand]) * 'Sugar Value'[Parameter Value] * 0.01,
1000)
*
MAX('DB'[Cost per Ton])
How can I get the total right?
Thanks.
Solved! Go to Solution.
@o59393 Try this, use the column you have on the rows:
Cost What If =
SUMX (
VALUES ( YourTable[ColumnOnRows] ),
DIVIDE (
CALCULATE ( SUM ( 'DB'[Demand] ) ) * 'Sugar Value'[Parameter Value] * 0.01,
1000
)
*
CALCULATE ( MAX ( 'DB'[Cost per Ton] ) )
)
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@o59393 the column you are using on the rows that will be in the values
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@o59393 Try this, use the column you have on the rows:
Cost What If =
SUMX (
VALUES ( YourTable[ColumnOnRows] ),
DIVIDE (
CALCULATE ( SUM ( 'DB'[Demand] ) ) * 'Sugar Value'[Parameter Value] * 0.01,
1000
)
*
CALCULATE ( MAX ( 'DB'[Cost per Ton] ) )
)
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k
What should i use as the YourTable[ColumnOnRows] within values? I put the table name but I get an error.
Also I put the " ) " afther the 0.01 to close the calculate argument and then divide by 1000
Thanks.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |