Compare results from Matrices with different filter combinations

[vbn]

Hi

I'm new to powerBI and trying to copy an existing PowerPivot report as a learning exercise.

I have 20+ detailed matrixes looking at the same data with different combinations of 8 slicers applied.

What i'd like to do is see the totals of these different visuals as an overview.

Right now the best solution I've found is creating new matrices for each in the same sheet and applying filters. However this means duplicating the value headers for every row, that the fields don't exactly line up easily, and it's not as quick and easy as clicking slicers.

Is there any possible way to store the results of filters or slicers and use them as values within another visual? Ideally as below: 

Filters	Customers	Transactions	Revenue	Average value
Product A, Recency B, Value C...	100	120	$  2,103.00	$             17.53
Product A, Recency C, Value C...	320	400	$  5,405.00	$             13.51
Product B, Recency B, Value A...	500	543	$13,632.00	$             25.10

Thanks

[v-yuta-msft]

@vbn ,

Generally, you may use dax function SELECTEDVALUE() or ALLSELECTED()  to achieve the values in your slicer.

Community Support Team _ Jimmy Tao

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