crear medida con calculate y datesYTD que no se afecte con otros filtros

[JoseOrlando]

como se puede crear una medida con calculate y filtro de fechas (datesytd), pero que no se vea afectada por otros filtros de la pagina (año por ejemplo)

es decir, que la medida siempre me de las ventas del año actual, sin importar los filtros de la pagina

gracias por su ayuda

[amitchandak · Accepted solution]

@JoseOrlando , Create these two column in your date table

Based on Today
Year Start date = startofyear([Date],"12/31") // give year end date of your choice
Day of Year =datediff([Year Start date] , [Date],Day) +1

And try measure like

YTD= CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year] =year(Today()) && 'Date'[Day of Year] <= Max('Date'[Day of Year]) ))
LYTD = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year] = year(Today())-1 && 'Date'[Day of Year] <= Max('Date'[Day of Year])))

OR

YTD=
var _min = date(year(today()),1,1)
var _day = datediff(_min, today(),day)+1
return
CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year] =year(Today()) && 'Date'[Day of Year] <= _day) )

LYTD =
var _min = date(year(today())-1,1,1)
var _max = date(year(today())-1,month(today()),day(today()))
var _day = datediff(_min, _max,day)+1
return
CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year] = year(Today())-1 && 'Date'[Day of Year] <= _day))