Create intersectionality based on 2 tables

[Anonymous]

Hello,

In short I want to dynamically select multiple characteristics to see their influence on an average score. I want to see all combinations and not just the top X.

My data is in 2 tables. Table A has a distinct ID column and then columns of characteristics e.g. gender, ethnicity (e.g. ID1, Male, Asain, ID2, Female, White).

Table B has an ID column, assessment column and a score column (e.g. ID1, Assessment 1, Score 70, ID1, Assessment 2, Score 40, ID 2 ....etc).

Both tables are linked by a unique ID bridge table.

My thoughts are that I want to show columnsof unique combinations of characteristics and the average score for each combination.

But I want to dynamically select the columns by a slicer. So I can have 1 or 5 columns that influence the average score.

Any help is much needed.

.

[amitchandak]

@Anonymous ,

The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?

refer if this help : https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[Anonymous]

Hello,

My data tables are as follows:

Table A

ID	Gender	Ethnicity	Disability
1	M	B	Y
2	M	W	N
3	F	A	N

Table B

ID	Assessment	Score
1	1	70
1	2	50
2	1	60
3	2	50

And the Output, I am after is:

If I select Gender and Ethnicity in a slicer:

Gender	Ethnicity	Average Score
M	B	60 average of ID 1
M	W	60 average of ID 2
F	A	50 average of ID 3
F	B	0 there are no F and B IDs
M	A	0 there are no M and A IDs
F	W	0 there are no F and W IDs

Or if I select just Disbility in a slicer:

Disability	Average Score
Y	60 average of ID 1
N	55 average of IDs 2 and 3

[v-easonf-msft]

Hi, @Anonymous 

I am afraid it is hard to achieve the dynamic table you want in powerbi, I will continue to follow this thread.

Hope others can share good ideas here.

Best Regards,
Community Support Team _ Eason