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

[Spudder112]

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.

[amitchandak · Accepted solution]

@Spudder112 , Try measures like

M1= distinctcount(Fact[Customer])

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

[Spudder112]

Thanks! This worked great.

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