Add Filtered Value to Each Row

[ejhornyak]

I have a table called Location List and a column called Year.  For my visuals I am using the Year Column as a Filter.

I want to do some additional analays so when I select a Year with the filter I want that value to show up in a new column in each row of the table.  From there I want to add a new column that does a simple if statement ( if(Year<= "Selected Year", 1,0)

Is something like that possible?

Thanks,

[v-yulgu-msft]

Hi @ejhornyak,

In your scenario, if the table visual fields are also from table 'Location', I would suggest you create an extra table containing the unique Year values, then, add this [Year] column from new table into slicer.

To get the slicer selection, you could refer to this measure:

Selected Year=SELECTEDVALUE('NewTable'[Year])

Best regards,

Yuliana Gu

[Anonymous · Accepted solution]

I guess it's not possible.
Unfortunately you can't get the slicer (filter) value.
If someone know how do it, please, share with us.

edit: maybe some workarround using dax (isfiltered or firstnonblank)