Average based on slicer selection

Question

So I am recording data, and using a slicer to show only specific data. But some of that data needs to be averaged based only on the data selected and not all the data. If I have 50 tests of type A and 20 tests of type B, I can use a slicer to show type A or type B, but the average I can't get to work correctly. here are screen shots to help understand

Type A:

And Type B

As you can see, the data on the left does not change, even though I am now looking at different types.

Any idea? I have exhausted my searches.

Just to note, I am showing the correct data in a line chart correctly, but would like the other information not in line chart (as shown here on the left) to be accurate just based on what I selected.

Answer 1

Hi abson365

The video below might help you.

Do let us know if you need more help

Regards

Jeovany

https://youtu.be/0bdhy0ty7Mc

Answer 2

Holy excel batman! At first I didn't think it would work, because it wasn't given the last cell of data, which I needed. Then I realized when I used the slicer, my averages wouldn't change. But adding the subtotal function, it is working exactly like I need! thanks!

Answer 3

Hi,

The kind of interactivity that you want with slicers can be achieved only with Pivot Tables. As and exception, we can use the PowerPivot, write DAX measures and then convert those measures into CUBE functions to get your desired result.