TOTALYTD is not working

[SivaReddy]

I loaded factinternetsales from adventureworks2016 database into powerbi. created totalytd column using following dax formula.

TOTALYTD= TOTALYTD(sum(FactInternetSales[SalesAmount]),FactInternetSales[OrderDate].[Date])

the above dax is not working. please find the below screenshot.

[Anonymous · Accepted solution]

Hi @SivaReddy ,

Try this formula.

Measure = CALCULATE(SUM('Table'[sales]),FILTER(ALLSELECTED('Table'),YEAR('Table'[date])=YEAR(SELECTEDVALUE('Table'[date]))&&'Table'[date]<=MAX('Table'[date])))

Best Regards,

Jay

[Samarth_18]

Hi @SivaReddy ,

If you have calender table/date table which connected to FactInternetSales table  then pass date column from calender/date table into totalytd function.

TOTALYTD ( SUM ( FactInternetSales[SalesAmount] ), Calender_table[Date] )

or you can try below code:-

TOTALYTD =
CALCULATE (
    SUM ( FactInternetSales[SalesAmount] ),
    YEAR ( FactInternetSales[OrderDate] ) = YEAR ( NOW () )
)

Thanks, 

Samarth

[SivaReddy]

I used fulldatealternativekey of dimdate. Still I am not getting ytd. please find the below screenshot.

dax formula used is TotalYTD = TOTALYTD(sum(FactInternetSales[SalesAmount]),DimDate[FullDateAlternateKey].[Date])

[Samarth_18]

What about below code?

TOTALYTD =
CALCULATE (
    SUM ( FactInternetSales[SalesAmount] ),
    YEAR ( FactInternetSales[OrderDate] ) = YEAR ( NOW () )
)