Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

SUM OF ANNUAL TARGETS with MONTHLY filter

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?

 

 

ANE2CAbo_0-1655038516480.png

 

Thanks for your support.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

ANE2CAbo

 

try this

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

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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

Have a good day.

v-rongtiep-msft
Community Support
Community Support

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'))

 

vpollymsft_0-1655261035104.png

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
Not applicable

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
Not applicable

ANE2CAbo

 

try this

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

Anonymous
Not applicable

Hello

 

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.