Divide Mont by YTD total

[sinanalmac]

Hi All I need to create a measure  Month by YTD 

This is my mesare

Measure 4 = CALCULATE(SUM(Rpl_SELL[TURNOVER]),ALLSELECTED(Rpl_SELL[MONTH],Rpl_SELL[YEAR]))

 
I want  to  divide   the month (the red one) to Current YTD(the blue one)

How can I do that?

[amitchandak]

@sinanalmac , You can get it using the date table and get measure like

example

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

or

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"3/31"))

and then try

[sinanalmac]

hi @amitchandak 
thank you  for your  help 

But  with your  measure, I Get the same result 

Best regards
Sinan 

[sinanalmac · Accepted solution]

Hi, 
I found the solution.

TurnoverYD = CALCULATE(SUM(Rpl_SELL[TURNOVER]), ALL(Rpl_SELL[DATE].[Year],Rpl_SELL[DATE].[Month],Rpl_Satis_Flow_Unisel[DATE].[Day]))

 This one  is  working on my dashboard