SUM OF ANNUAL TARGETS with MONTHLY filter

[Anonymous]

Dear All

I'm building a graph with following measures:

Annual targets vs. Actual YTD target

For "Actual YTD target" the calculation works: when the user flags feb, por exemplo, the measure takes the sum of Jan + Feb.

But for Target i don't want YTD, but the yearly/annual target. Can do i build this measure since i still have month as part of my filter?

Thanks for your support.

[Anonymous]

@Anonymous  your proposal worked! thanks very much for your support. I already accepted it as solution.

Have a good day.

[v-rongtiep-msft]

Hi @Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

target_all = CALCULATE(SUM('Table'[value]),ALL('Table'))

If I have misunderstood your meaning, please provide your desired output with more details and you sample pbix file without privacy information.

Best Regards

Community Support Team _ Polly

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

[Anonymous]

Hi @Anonymous  but i need the month filters for YTD calculation.

I'm trying something on this direction, but it's not working:

Test = CALCULATE([MTD EUR TGS], ALLSELECTED('dCalendar'[Year]))

[Anonymous · Accepted solution]

ANE2CAbo

try this

Test = CALCULATE([MTD EUR TGS], keepfilters('dCalendar'[Year]),REMOVEFILTER(('dCalendar'[Month]))

[Anonymous]

Hello

Yes you can. You remove month filter and keepfilters on year and all(dates)