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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.