Filter a table with measure

Hi,

I have the following table

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 

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