Forum Discussion

Helper I

6 years ago

Solved

Row level calculation, with variable elements, can't get total right. HELP!

I've been working in DAX for a while, but am still a neophite. I'm sure this is a no brainer for you guys, but I am STUCK! I need a measure to calculate a Cost by Customer. The basic calculatio...

column total

DAX Calculation

sumx

Greg_Deckler
6 years ago
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Greg_Deckler

Community Champion

6 years ago

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

twilbour

Helper I

6 years ago

Thank You...The Summarize in your second post solved my problem! Y'all are awesome.

Forum Discussion

Row level calculation, with variable elements, can't get total right. HELP!

Related content

Dynamic Variable in Calculated Columns

Understanding variable calculation

Calculate sumproduct with variable values

DAX Calculated Column with "variable tables" as variables.

MoM calculation