Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
lynnsop
Helper I
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.

 

Thanks in advance 🙂

1 ACCEPTED SOLUTION
amitchandak
Super User
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])))

View solution in original post

1 REPLY 1
amitchandak
Super User
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])))

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.