Slicer should filter all the tables

[Anonymous]

Hello All, 

i have 2 tables 

1) Substation 

Year	State	Substation	Substation#	System	Project phase
2020	AZ	Wells 49	332549	Distribution Line	MODEL
2020	AZ	Heavener 22	351422	Distribution Line	MODEL
2020	AZ	Otter 41	435341	Distribution Line	MODEL
2020	AZ	Lone Grove 23	512523	Distribution Line	MODEL
2020	AZ	Wells 49	332549	Distribution Line	PLAN
2020	AZ	Heavener 22	351422	Distribution Substation	PLAN
2020	AZ	Otter 41	435341	Distribution Line	PLAN
2020	AZ	Lone Grove 23	512523	Distribution Substation	PLAN

2) Labor

Year	State	Substation	Substation#	System	Labor Type	Project Phase
2020	AZ	Wells 49	332549	Distribution Line	Design	MODEL
2020	AZ	Heavener 22	351422	Distribution Line	Execution	MODEL
2020	AZ	Otter 41	435341	Distribution Line	Design	MODEL
2020	AZ	Lone Grove 23	512523	Distribution Line	Execution	MODEL
2020	AZ	Wells 49	332549	Distribution Line	Engineering	PLAN
2020	AZ	Heavener 22	351422	Distribution Substation	Construction	PLAN
2020	AZ	Otter 41	435341	Distribution Line	Engineering	PLAN
2020	AZ	Lone Grove 23	512523	Distribution Substation	Construction	PLAN

i am joining my 2 tables with Substation number (Substation table filters the Labor table)
when i keep the Project Phase as the slicer, i am not getting the results as excepted

Example
my slicer Project Phase from table Substation

when i select PLAN in the slicer Project Phase, the Labor table is not filtering to the Plan (showing both the Plan and Model data)

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Try this one:

Measure 2 = IF(ISFILTERED(Substation[Project phase]),IF(MAX(Labor[Project Phase])=SELECTEDVALUE(Substation[Project phase]),1,0),1)

 

[mhossain]

@Anonymous 

@mahoneypat  has correctly stated the reason, but still if you want to filter as you mentioned in your questions, you can create combined key (Substation# & Project phase) in both of the tables and create join on this, slicer will filter accordingly.

Let me know if above makes sense.

[mahoneypat]

The filtering is happening but you are still seeing both values because both values exist in the Labor table for at least one of the values in the Substation table that has value of Plan for Project Phase (e.g., 332549).

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat