Create a Measure for below logic

[SK87]

I have one problem kindly help me to sort this out:
I have one data set in which brands and respective their respective search values are there. And I have another dataset in which I have done unpivoting and have one column name as Attributes and other as Values. Based on these Attributes values are present and their respective brand is present.
Now, I need to implement a relation between these two datasets as if in 'Data2', Attributes = A then Values should be > 0 and based on this brands should pick in the table.

Attributes would be in Slicer (A,B,C and D as dropdown). In Table in Rows as "Brand" variable . But when I select "A" in Slicer then in table I should see only sub categories of A same with B, C and D.

Brand	SI	A	B	C	D
B	0.839881	0	1	0	0
Bb	6.514407	0	2	0	0
Bbb	0.03975	0	3	0	0
B	0.894615	0	1	0	0
A	1.0485	1	0	0	0
Aa	0.449527	2	0	0	0
Aaa	0.36436	3	0	0	0
A	0.965964	1	0	0	0
Aa	0.374718	2	0	0	0
Aaa	0.353337	3	0	0	0
A	1.490134	1	0	0	0
Aa	0.545735	2	0	0	0
Aaa	0.499831	3	0	0	0
A	1.330859	1	0	0	0
Aa	0.465794	2	0	0	0
Aaa	0.415787	3	0	0	0
A	1.1346	1	0	0	0
Aa	0.36904	2	0	0	0
A	1.324011	1	0	0	0
Aa	0.505575	2	0	0	0
Aa	0.097057	2	0	0	0
Aaa	0.57688	3	0	0	0
C	2.125201	0	0	1	0
Cc	2.168612	0	0	2	0
Ccc	2.037037	0	0	3	0
C	0.982363	0	0	1	0
Ccc	1.298314	0	0	3	0
C	2.849901	0	0	1	0
Cc	1.189786	0	0	2	0
Ccc	3.248163	0	0	3	0
Dd	8.476445	0	0	0	2
D	2.224267	0	0	0	1
Ddddd	0.034427	0	0	0	5

Dataset2 (unpivot)

Market	Brand	SI	Attributes	Values
US	B	0.839881	B	1
US	Bb	6.514407	B	2
US	Bbb	0.03975	B	3
US	B	0.653297	B	1
US	Bb	4.452887	B	2
US	Bbb	0.040627	B	3
US	B	0.781134	B	1
US	A	1.0485	A	1
US	Aa	0.449527	A	2
US	Aaa	0.36436	A	3
US	A	0.965964	A	1
US	Aa	0.445827	A	2
US	Aaa	0.273562	A	3
US	Aaa	0.320927	A	3
US	Aaa	0.224143	A	3
US	C	2.125201	C	1
US	Cc	2.168612	C	2
US	Ccc	2.037037	C	3
US	C	0.982363	C	1
US	Cc	0.946146	C	2
US	Ccc	1.122596	C	3
US	Ccc	0.77872	C	3
US	C	0.457525	C	1
US	Dd	8.476445	D	2
US	D	2.224267	D	1
US	Ddddd	0.034427	D	5

Output

[SK87 · Accepted solution]

I solved it.

Thanks everyone for your help.

[v-easonf-msft]

Hi, @SK87 

Not sure what you mean. What is your expected result?
What fields need to be added to column and value in Martix?

Best Regards,
Community Support Team _ Eason