Using two measures to filter table

Question

HiBeing new to DAX, I am stuck and would appreciate some help. My data table has many columns of which one is the Financial Year. I would like the user to select any financial year in a slicer and would then display the data for the selected year as well as the previous year. I made two measures, SelectedFY and PreviousFY. I wanted to use these measures to filter the data, but it only works when I hardcode the variables.So this works:TableFILTER = VAR SFY = "FY22"VAR PFY = "FY21"VAR FilteredData = FILTER(ALL(DataAll),DataAll[TheFinYear]=SFY || DataAll[TheFinYear]=PFY)RETURNFilteredDataBut if I change the variables to equal the measures, the table filter returns nothing:VAR SFY = [SelectedFY]VAR PFY = [PreviousFY]&nbsp;

manoj_nair · Accepted Answer

WillemvB&nbsp;- try this solution and let me know if this resolve your problem. attached&nbsp;pbix file&nbsp;If my post helps you to find solution would be happy if you could mark my post as a solution and give it a thumbs up&nbsp;Best regardsManoj NairLinkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/

Forum Discussion

Using two measures to filter table

2 Replies

Related content

Using measure as a filter

Measure used as a Filter breaks another measure

Dynamic measure filtering

Filter by Rank measure

Filter data using slicer