respect slicer but not table

[powerbityro]

hi all,

i have following measure

test = IF ( HASONEVALUE(calender[year]); VALUES(calender[year])-5 )

i use this and not selctedvalue because i work with the live connection. when i for example select the slicer year = 2019 i want following table:

year test

2019 2015

2018 2015

2017 2015

2016 2015

2015 2015

but i get

year test

2019 2014

2018 2013

2017 2017

2016 2016

2015 2015

can i somehow except the year in the table but not the slicer?

[v-chuncz-msft · Accepted solution]

@powerbityro 

Make sure the [year] column dragged to table visual comes from another table that has no relationship with the slicer.

[Anonymous]

Because it is a dynamic measure. You should try this:

test = IF ( HASONEVALUE(calender[year]); VALUES(TODAY(calender[year])-5 )

or this

test = IF ( HASONEVALUE(calender[year]); VALUES(TODAY()-5 )

or this

test = IF ( HASONEVALUE(calender[year]); VALUES(YEAR(TODAY())-5 )

I dont remember the proper way, but the idea is to use today's year instead of the five years less than the selected value.

[powerbityro]

TODAY dont work

[Anonymous]

Try using Max(Year), Max(Month), Max(Day) or something like that