Forum Discussion

Faye1901's avatar
Faye1901
Icon for Helper I rankHelper I
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Does this measure work?

$ Value YTD = calculate([$ Value],datesytd('dim A - Transaction Date'[Calendar Date],"7/31"))