Using DAX to make Visual level Filter

[giorgi_lommidd]

Hi All, 
I have table with some values on Y axis and  Date on X axis.  Date ranges from dtStart to dtEnd . The data range changes dynamically.  I need to show data only for year = year(dtEnd) -1, withoute using filters.    

[v-lili6-msft · Accepted solution]

hi, @giorgi_lommidd 

You could add a conditional in your formula

for example:

Measure = var lastenddate=CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table')) return
CALCULATE(SUM('Table'[Value]),FILTER('Table',DATEDIFF('Table'[Date],lastenddate,DAY)>365))

Result:

here is demo pbix, please try it.

If not your case, please share a simple sample pbix file and your expected output.

Best Regards,

Lin