Distinct count with value > 0 in another table

[brunozanoelo]

Hello my friends, I´m having one issue here, can someone help me?

I have three tables:
- Sales (Client ID in her) => Clients  (City ID in her) => Cities

What I need:
Distinct count of Cities that have sales;

How can I do this?

[amitchandak · Accepted solution]

@brunozanoelo , Try a new measure like

calculate(distinctcount(client[city]), filter(sales, not(isblank(sales[amount]))))

[brunozanoelo]

Thank you @amitchandak !

Have a great day my dear friend;

Best Regards from Brazil.