Is it possible to use slicer selected value as flag column?

[emmanuelvallejo]

Context:
I have one tables on PowerBI
Activity:

Date	Store	Sales	Gross Margin
01/01/2021	Branch 1	10000	2000
01/02/2021	Branch 1	20000	4000
01/03/2021	Branch 1	15000	3000
01/04/2021	Branch 1	21000	4100
01/05/2021	Branch 1	30000	6000

I have a Date slicer having the list of dates on this table.
I need to add a column indicating if the date is before or on, from the value selected on the slicer,
For example if 01/03/2021 is selected on the slicer I want this flag column:
This column needs to be dynamic, is this possible?
 

Date	Store	Sales	Gross Margin	Flag
01/01/2021	Branch 1	10000	2000	1
01/02/2021	Branch 1	20000	4000	1
01/03/2021	Branch 1	15000	3000	1
01/04/2021	Branch 1	21000	4100	0
01/05/2021	Branch 1	30000	6000	0

[stevedep · Accepted solution]

Hi @emmanuelvallejo ,

Assuming its semantics, and that you don't mind that its a measure, yes, its possible. Please see below:

Hope that this works for you?

Kind regards, 

Steve. 

[emmanuelvallejo]

Hello Steve,
It works this way, I guess I can move forward on the solution using it.
Thanks for you reply and example 

[lbendlin]

No. You can only modify measures based on filter selections. calculated columns are not impacted by filters.