Need a static straight line in 'Stacked and column bar chart' with current YTD sales

[Anonymous]

Right now,
I have Sales on Y-axis.
I am getting a dynamic line for YTD[Sales] for various months on X-axis. Instead, I want a static line with constant value of current YTD[Sales]. 

For eg. I am getting YTD[Sales] as one of the blue lines here for different months; I am getting previous months' YTD[Sales] which I don't require.

How can I get one straight blue line for YTD[Sales] until current month?

[Anonymous · Accepted solution]

Hi everyone, I tried all the mentioned methods but nothing worked for me.

My Dax formula was Calculate(DIVIDE(YTD(X), YTD(X) + YTD(Y))), but it was giving not a fixed line.

I created a variable for above DAX formula and returned using 

CALCULATE( calculated_variable ,Datefield  = TODAY())

and it worked!

Thanks everyone for help though.

[MFelix]

Hi @Anonymous

Not getting the correct question based on the text compared to the image, you want to have a straigth line in your visualization or do you want the line growing until the current month?

If you want a straighline you need to add a measure similar to:

TotalYTD= CALCULATE(TOTALYTD(SUM('Table'[Values]), 'Table'[Date]), ALLSELECTED('Table'[Date])
)

[parry2k]

@Anonymous what measure you used for YTD Sales can you share the DAX expression?