Forum Discussion
Calculate Sales by Delivery Country
Yep, so it's the same formula you are using currently with your measures, but put a "Calculate" function around them. Should look something like this:
PY_USA = Calculate(your existing previous year formula, filter('Countries', 'Countries'[name]="USA"))Same with the Previous year -1.
So, what happens is if there are no locations of a customer within the country, your total for this measure should result in 0
Keith-Sayer Thanks for your advice 🙂 I do want to try out the option with the measures, just to see how it looks like. Do you have an idea what the DAX-formula for this would be?
Resolver IYep, so it's the same formula you are using currently with your measures, but put a "Calculate" function around them. Should look something like this:
PY_USA = Calculate(your existing previous year formula, filter('Countries', 'Countries'[name]="USA"))
Same with the Previous year -1.
So, what happens is if there are no locations of a customer within the country, your total for this measure should result in 0