Display Values only for the last year if no filter is selected - DAX

[Anonymous]

Hello everyone,

I have a question that I think is simple but I'm not getting it.

I wanted to see values only in the last year, if no filter is selected:

YEAR: (all)

Month		Value
Jan 20
Feb 20
Mar 20
(....)
Dec 20
Jan 21		123
Feb 21		3232
Mar 21		32323

Thank you very much in advance for your help,
Simão

[amitchandak · Accepted solution]

@Anonymous , Assume you have a year column too

measure =
var _1 = year(today())-1
return
if(isfiltered(Table[Year]) , calculate(sum(Table[Value])),calculate(sum(Table[Value]), filter(Table, Table[year] =_1)))

or

measure =
var _1 = year(today())-1
return
if(isfiltered(Table[Month]) , calculate(sum(Table[Value])),calculate(sum(Table[Value]), filter(Table, Table[year] =_1)))

[Anonymous]

Thank you very much!

This is just what I was looking for!