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
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.
Solved! Go to Solution.
ANE2CAbo
try this
Test = CALCULATE([MTD EUR TGS], keepfilters('dCalendar'[Year]),REMOVEFILTER(('dCalendar'[Month]))
@Anonymous your proposal worked! thanks very much for your support. I already accepted it as solution.
Have a good day.
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
Hi @Anonymous but i need the month filters for YTD calculation.
I'm trying something on this direction, but it's not working:
ANE2CAbo
try this
Test = CALCULATE([MTD EUR TGS], keepfilters('dCalendar'[Year]),REMOVEFILTER(('dCalendar'[Month]))
Hello
Yes you can. You remove month filter and keepfilters on year and all(dates)
User | Count |
---|---|
158 | |
109 | |
96 | |
84 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |