Use Column 1 values to filter Column 2 and return column 1 values for same table

[Anonymous]

Hi good people,
In the below example i want to see the stores affected by a particular store . The table is imagined as below.

S.no	Store Affected	Affected by
1	S01
2	S02	S01
3	S03
4	S04	S03
5	S05	S02
6	S06	S02

So if the user selects S02 in "Stores Affected" Column the new table visualization need to display 

Stores Affected

S05

S06

Im very new to coding. Please help me get this in DAX. Thank you so much 

P.S: I have to use the "stores affected" column as my slicer I cannot use "Affected by" column as slicer

[v-lionel-msft]

Hi @Anonymous ,

How about this?

You need to create another table.

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-lionel-msft ,
Thank you for the reply. I can use selectedvalue(Sheet1'Stores Affected') instead of creating a new table right ? i tried both ways it doesnt work for my problem unfortuantely

[v-lionel-msft]

Hi @Anonymous ,

It is impossible to filter one value in the [Store Affected] column and return other values in the same column.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[fhill]

Is this what you are doing / seeing?  I have 'Affected By' column in my slicer.

[Anonymous]

Yes the result is correct but I cannot use the "affected by" column as my slicer. I need to use "Stores Affected" Column as my slicer.

Thank you

[Anand24]

Hi @Anonymous ,

You don't need DAX for this.

Take a table visualization with "Store affected" field in it.

Now take a slicer visualization with"Affected By" field in it and choose any store in the slicer visualization to filter the above table with affected stores.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anonymous]

hi @Anand24 ,
Thanks for replying . I cannot use the "affected by" Column as my slicer, ( this is small part of a bigger picture im trying to solve so its has to be stores affected column as my slicer) Do i need to create a separate table and then link it with one to one connection ?  

[Anand24]

Hi @Anonymous ,

You can't take same field(Stores affected) in slicer and table visualizations in this case.

[fhill]

@Anonymous 

I wonder if we are missing a key part here.  Do you want the 'Affected by' Column to go away, or how is this different that just a Slicer selection of the 'Affected By' data?

FOrrest

[Anonymous]

you just need to create a slicer, then drag Stores Affected into it. 

[Anonymous]

Hi @Anonymous ,
If i do that it is just going to return filter with S02 

Store Affected	Affected by
S02	S01

My requirement is it should take S02 from Store affected Column and store in Var say 'amp' and filter with 'amp' in column "Affected By" which will return 

Store Affected	Affected by
S05	S02
S06	S02

And those 2 stores S05 and S06 are the ones that should be displayed