Use one slicer to filter multiple cards by different categories

[drewnigh]

I would like to filter three cards differently based on one slicer. (This is a simplified from my actual scenario.)

I have two data tables:

• List of companies along with their industry and type of test
• List of members (employees) along with their industry, type of test, and score

I also have a slicer that chooses a company.

I would like to have three cards that give the average score:

• for all members in the same industry
• for all members using the same test type
• for all members in same industry and using the same test type

The problem is that when I use the slicer, all the cards get filtered by both industry and test type.

I am using Power BI desktop version Sept 2021.

Here's is what I have so far:

The cards on the left use the slicer but the bottom two are incorrect. The cards on the right are correct, but use a manual filter and don't respond to the slicer.  The tables on the far right show the other averages that should show up when the slicer is changed.

Here is my data:

Company	Industry	Type	Concat
A	Construction	1	Construction1
B	Education	1	Education1
C	Manufacturing	2	Manufacturing2
D	Manufacturing	1	Manufacturing1
E	Construction	1	Construction1
F	Manufacturing	2	Manufacturing2
G	Education	1	Education1
H	Manufacturing	1	Manufacturing1
I	Education	2	Education2

Member	Industry	Type	Score	Concat
1	Education	2	32	Education2
2	Education	2	42	Education2
3	Construction	1	53	Construction1
4	Education	2	32	Education2
12	Construction	1	62	Construction1
13	Education	2	60	Education2
14	Education	2	45	Education2
15	Education	2	67	Education2
16	Education	2	69	Education2
17	Education	1	37	Education1
18	Construction	2	47	Construction2
19	Education	1	56	Education1
31	Manufacturing	2	66	Manufacturing2
45	Education	2	66	Education2
46	Construction	2	42	Construction2
47	Construction	2	51	Construction2
48	Manufacturing	2	70	Manufacturing2
49	Education	2	50	Education2
50	Manufacturing	1	48	Manufacturing1
51	Education	2	62	Education2
52	Manufacturing	2	51	Manufacturing2

I created this linking table that I thought might help with the filtering:

Industry	Type	Concat
Construction	1	Construction1
Construction	2	Construction2
Education	1	Education1
Education	2	Education2
Manufacturing	1	Manufacturing1
Manufacturing	2	Manufacturing2

Here are my relationships (joined on Concat):

My Power BI file can be accessed here:

https://1drv.ms/u/s!Auf12VlCEsoEsEjNEP2YMUtOujjG

Thanks!

[Anonymous · Accepted solution]

Hi @drewnigh ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create two measures. 

AVG Score for Type = AVERAGEX(FILTER(ALL('Members'),[Type]=SELECTEDVALUE(Companies[Type])),[Score])

AVG Score for Industry = AVERAGEX(FILTER(ALL('Members'),[Industry]=SELECTEDVALUE(Companies[Industry])),[Score])

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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