cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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


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

@ me in replies or I'll lose your thread!!!

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Highlighted
Super User IX
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


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

@ me in replies or I'll lose your thread!!!

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

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

Re: Wrong totals with dax formula

Hasonevalue
Highlighted
Microsoft
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

Re: Wrong totals with dax formula

Reply posted back to link.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors