Measure equals to/larger than shows blank results
Hi masters, i have the following measure, which counts the customers who have more than zero referrals for the last 6 month and WORKS FINE: Customers MGM Referrals L6 Months = CALCULATE(Customers[# Customers],filter(MGM,[MGM Referrals NEW L6 Months]>0)) BUT: when i want to calculate those with exactly 1 referral it shows blank: Customers MGM Referrals L6 Months 1 = CALCULATE(Customers[# Customers],filter(MGM,[MGM Referrals NEW L6 Months]=1)) It shows blanks for any "equal/larger than x". Please note that the above combines 2 different data tables (Customers & MGM). Any idea??? i am lost here. Thanks in advance, Amit