Slicer on measure

[SCannaerts]

Hello,

I have this measure "current year - previous year":

CALCULATE(SUM('Turnover'[Turnover]), YEAR('date'[Date])=YEAR(Today()))-CALCULATE(SUM('Turnover'[Turnover]), YEAR('date'[Date])=YEAR(Today())-1)

When I use a quarter slicer (q1, q2, q3, q4) based on the quarter on the Date Hierarchy in the date table the results of the measure don't change. 

How can I solve this?

Thanks

[Ashish_Mathur]

Hi,

There should be a relationship from the Date column of the Turnover table to the Date column of the Date Table.  In the Date Table, you should have columns for Year, Month name and Month number.  Sort the Month name by the Month number.  To your slicer, drag Year from the Date Table.  Write these measures

Total = sum('Turnover'[Turnover])

Total in PY = calculate([Total],previousyear(Date[Date]))

Diff = [total]-[total in PY]

Hope this helps.

[v-luwang-msft · Accepted solution]

Hi @SCannaerts ,

Try to use the below dax ,if not work ,could you pls share sample data,remember to remove confident data.

daxx =
CALCULATE (
    SUM ( 'Turnover'[Turnover] ),
    FILTER ( ALL ( 'date' ), YEAR ( 'date'[Date] ) = YEAR ( TODAY () ) )
)
    - CALCULATE (
        SUM ( 'Turnover'[Turnover] ),
        FILTER ( ALL ( 'date' ), YEAR ( 'date'[Date] ) = YEAR ( TODAY () ) - 1 )
    )

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien