Filter a table with measure

[rodfernandez]

Hi,

I have the following table

Aspect	Type	Software
1.1	A	XX
1.2	A	XX
1.3	A	XX
1.4	A	XX
1.4	A	XX
1.1	A	XX
1.2	B	ZZ
1.2	A	ZZ
1.2	A	ZZ
2.1	A	XX
2.2	A	ZZ
2.3	A	YY
2.2	A	XX
2.1	B	YY
2.3	A	YY
1.1	A	XX
1.4	A	YY
2.2	A	YY
2.3	C	XX
1.3	A	YY

and I would like to filter this table with a measure, the filter can not be a page level filter. the filter must only show Type A.
then I should group every Aspect and count the amount for each Software. So the measure should throw a table somthing like this 

Aspect	XX	YY	ZZ
1.1	3
1.2	1		2
1.3	1	1
1.4	2	1
2.1	1
2.2	1	1	1
2.3		2
Total	9	5	3

Then I want to create a cake graph with 4 parameters (Yellow, Orange, Green and Blue) were the amount for each parameter have this following rule 

Thanks

[v-cherch-msft · Accepted solution]

Hi @rodfernandez

You may create measures to get the visual. Please refer to the attached sample file.

Regards,

Cherie