Calculate Average from Count of selected rows from slicer

[lynnsop]

Hello people.

I want to calculate the average of a variable depending on how many multiselects I do on my Slicer.

For example I select on my slicer two rows:
2021-04

2021-05

Table for those two selections:

Date         Percentage

2021-04    97

2021-05    99

No I want a card which doesnt add 97 and 99 (currently showing 196) but take the average of both showing 98.

How can I realize this with a measure which I can simply assign to the card?

Obviously this should work for all amounts of selections, etc.

Thanks in advance 🙂

[amitchandak · Accepted solution]

@lynnsop , New measure

If percent is a measure

averagex(Values(Date[Date]), [percent])

If this a column

averagex(Values(Date[Date]), calculate(average(Table[percent])))