Forum Discussion
YTD Measure with Filter Context
Hi All
I have a YTD measure with a view to showing the YTD total value of some product, but it loses the filter context applied to the page. I need a YTD that keeps filter context.
See current measure here: $ Value YTD = TOTALYTD([$ Value], 'dim A - Transaction Date'[Calendar Date], allselected('dim A - Transaction Date'[Financial Year Short]), "7/31")
I'm expecting the sum of the Current Year $ from the summary table but I'm getting something totally different because of the filter context issue.
Cheers
Faye
Faye1901
Did the above replies helped you to solve your problem. If so please mark the solutions.If not, you may try ALL(Table) as the filter context.
$ Value YTD = TOTALYTD([$ Value], 'dim A - Transaction Date'[Calendar Date], All('dim A - Transaction Date'), "7/31")Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
please provide sample data and expected output.
Faye1901 - I agree with lbendlin
But, you may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008Hi,
Does this measure work?
$ Value YTD = calculate([$ Value],datesytd('dim A - Transaction Date'[Calendar Date],"7/31"))
Hi Faye1901 ,
I think you need to change the allselected() function to allexcept() function.
$ Value YTD = TOTALYTD([$ Value], 'dim A - Transaction Date'[Calendar Date], allexcept('dim A - Transaction Date'[Financial Year Short]), "7/31")Please try.
Aiolos Zhao
Faye1901
Did the above replies helped you to solve your problem. If so please mark the solutions.If not, you may try ALL(Table) as the filter context.
$ Value YTD = TOTALYTD([$ Value], 'dim A - Transaction Date'[Calendar Date], All('dim A - Transaction Date'), "7/31")Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
