Forum Discussion

GunnerJ's avatar
GunnerJ
Post Patron
6 years ago

Values not summing

I need to show the sum of a customer's bills (they can have multiple account #s but when I try to sum them up or use the filters it's not working as expected.    This was my attempt to calculate th...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi GunnerJ ,

Try using the FILTER function when filtering with a true/false expression along with CALCULATE, just like the below:

 

Customer last bill total = CALCULATE(SUM('Customer Bills'[Sum of Charges by Month]),
ALLEXCEPT('Customer Bills','Customer Bills'[Sum of Charges by Month]), 
FILTER('Customer Bills',  [Most Recent Bill] = 1))

This should fix the error.

 

Cheers,
Robin

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.