Measure equals to/larger than shows blank results

[akfir]

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

[Anonymous]

Hi @akfir ,

Unfortunately, according to the information you provided, it is difficult for me to give the correct answer. Could you provide more detailed content ? such as sample model.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@akfir , if MGM Referrals NEW L6 Months is a measure, then try Like

Customers MGM Referrals L6 Months 1 = countx(filter(Values(Customers[# Customers]),[MGM Referrals NEW L6 Months]=1),[# Customers])