topic Re: Is it possible to use slicer selected value as flag column? in DAX Commands and Tips

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

emmanuelvallejo — Fri, 26 Feb 2021 20:19:55 GMT

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

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

lbendlin — Sun, 28 Feb 2021 03:39:12 GMT

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

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

stevedep — Sun, 28 Feb 2021 05:17:18 GMT

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.

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

emmanuelvallejo — Mon, 01 Mar 2021 21:14:33 GMT

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