Forum Discussion
DAX Calculation Aggregation not working
Anonymous
Anytime I have a complex measure that does not behave as I expect, I break it into separate parts.
Funding Sum = Sum(Funding)
Revenue Sum = Sum(Revenue)
Burn Total = [Funding Sum]-[Revenue Sum]
Drop them all into a table and see where the breakage occurs. Fix the individual calculation that isn't working appropriately. Keep in mind that measure themselves do not take up room in the model and only calculated as used. If the measures work individually, build them into one useing VAR.
Burn Total =
VAR FundingSum = Sum(Funding)
VAR RevenueSum = Sum(Revenue)
RETURN
FundingSum - RevenueSum
Anonymous
Anytime I have a complex measure that does not behave as I expect, I break it into separate parts.
Funding Sum = Sum(Funding)
Revenue Sum = Sum(Revenue)
Burn Total = [Funding Sum]-[Revenue Sum]
Drop them all into a table and see where the breakage occurs. Fix the individual calculation that isn't working appropriately. Keep in mind that measure themselves do not take up room in the model and only calculated as used. If the measures work individually, build them into one useing VAR.
Burn Total =
VAR FundingSum = Sum(Funding)
VAR RevenueSum = Sum(Revenue)
RETURN
FundingSum - RevenueSum
For prosterity. I used your troubleshooting method and realized it was actually an interaction in another slicer that technically shouldnt have had an impact, once that was turned off everything worked. Thanks again!
Anonymous
And that situation is exactly why I still use that troubleshooting method. Rob Collie taught me that whole of any calculation is the sum of its parts and to inspect what I expect.
Happy your found your issue.