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
Spudder112
Helper I
Helper I

Looking for the best way to count values that meet a certain criteria across different tables

Hello,

 

Basically I have the following tables:

 

DimLocation

Zip

Location

 

FactLocation

Location

Employee

Customer

 

I want to be able to find how many employees work for more than 1 customer in each zip code. 

 

Let me know if more info is needed.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Spudder112 , Try measures like

M1= distinctcount(Fact[Customer])

 

M2=  countrows(filter(Summarize(Fact, Fact[Employee], DIm[Zip]), [M1]>1) )

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Spudder112 , Try measures like

M1= distinctcount(Fact[Customer])

 

M2=  countrows(filter(Summarize(Fact, Fact[Employee], DIm[Zip]), [M1]>1) )

Thanks! This worked great.

 

If you know of any resources to learn about using summarize within DAX formulas, I would utilize them. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.