Average not being affected by month slicer

[Anonymous]

Hi!

I have a table that looks like somewhat like this:  

Date and Time	How do you value or mkt?	How do you value our support?
20/10/20 7:00:00	8	7
15/10/20 8:00:00	8	7
03/09/20 10:00:00	5	4

I made a card visual, with the mean of the MKT values, but when I select a month on the slicer filter, it doesn't change the mean value. 

To be clear: I want to have a visual showing that the mean of october - the month we're at, so when we're at november, it'll show november and so on - of mkt (8), and another showing the mean of support (7) and so on. And another visual showing that comparing to september ( mean 5),  mkt increased in 60% and support increased in 75%, for example.

I also want to know if I need to make a measure for each of those columns or if it's possible to make the mean by the column I have selected.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Like this?
Please refer to my .pbix file.

Best regards,
Lionel Chen

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