Help with sales goals

[Syndicate_Admin]

I'm setting monthly sales goals and comparing it to actual sales. Everything works well when I apply filters every month.

But when I try to select two months, the goals don't add up.

My Goals Table

All right when I select a single month.

DAX used:

Monthly Goal =

CALCULATE(

MAX(Goals[Meta Sales]),

TREATAS(VALUES(Calendar[Month]),Goals[Month])

)

But when I select more than a month, the goals don't add up.

[prateekraina]

Please Upvote my answer if I helped you in resolving the issue 🙂

[prateekraina · Accepted solution]

Use SUM instead of MAX in your DAX expression Prateek Raina

[Syndicate_Admin]

Thank you so mucho...