Apply a filter to DIstinctcount of another table

[1001]

Hi, I wish to wrrite a DAX to apply a FILTER for a table column to a DISTINCTCOUNT of another table. 

Essentially, using a table, I wish to count the number of suppliers supplying to three indfividual shops.

DISTINCTCOUNT (Table 1 [Suppliers], FILTER (Table 2 [Shop 1]))

Any help wold be appreciated. Thanks.  

[v-zhangti · Accepted solution]

Hi, @1001 

I've simulated some data that I hope fits your situation.

Sample data:

Measure = 
CALCULATE (
    DISTINCTCOUNT ( 'Table 1'[Suppliers] ),
    FILTER ( ALL ( 'Table 2' ), [Shop] = "Shop 1" )
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

how are these tables linked?  can you provide some sample data from the tables in text form with a screenshot of what your data looks like?