cancel
Showing results for
Did you mean:
Highlighted
Anonymous
Not applicable

Wrong totals with dax formula

Hi experts

Using the following formula which is giving me the correct monthly values but the wrong overall
CALCULATE([TotalAssessments],FILTER(ALL(DimDate),DimDate[Year]=MAX(DimDate[Year])-1),SAMEPERIODLASTYEAR(DimDate[Date]))

Cannot see the error...

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX

Re: Wrong totals with dax formula

Is this in a table or matrix?

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

---------------------------------------

I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

5 REPLIES 5
Highlighted
Super User IX

Re: Wrong totals with dax formula

Is this in a table or matrix?

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

---------------------------------------

I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Anonymous
Not applicable

Re: Wrong totals with dax formula

Hi Greg

Yes to the matrix table. So how would I wrap this around my formula..this is where I get stuck...
Highlighted
Anonymous
Not applicable

Hasonevalue
Highlighted
Microsoft

Re: Wrong totals with dax formula

@Anonymous,

It seems that you post the question using a different id in this thread, please check my reply there.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable