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
someplaceorothe
New Member

Average Based on Multiple Filters & for Matching Records

Hello DAX Wranglers,

Is there a way to calculate the average based on multiple filters and a column with the matching matching entries . All my data is on a single table. Esentially after applying the filters if there are records under both AVG of those values need to be calculated. . I have attached a Sample Data

 

https://drive.google.com/file/d/1VdKKG5w7DMxMpN_kKM5KxC8Jncd2NKnb/view?usp=sharing

 

someplaceorothe_0-1714849714475.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1 REPLY 1
lbendlin
Super User
Super User

lbendlin_0-1714867084739.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors