cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

Calculate Average from Count of selected rows from slicer

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.

1 ACCEPTED SOLUTION
Super User

@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])))

Super User

@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])))