DAX measure - Distinct count referencing second table

[Panta]

I have two tables in my model: Sales table and Products table.

Sales table contains columns: Year; Customer_name; Product_Name; Sales_Amount.
Product table contains columns: Product_Name; Brand_Name

I need to create two measures to show:

1. Count of distinct products purchased by a customer in a given year
2. Count of distinct Brands purchased by a customer in a given year.

I did task 1 with the following function:
ProductCount_2020 = CALCULATE(DISTINCTCOUNTNOBLANK(Sales[Product_Name]); 'Calendar'[Year] = 2020)

I need help for the second task: how to get the count of distinct brands purchased by a customer on the basis of distinct products purchased? (i.e. how to reference the second table that relates products to theri brands?)

Thank you

[Panta]

Thank you.

1. The YT video did not help - it is just an elementary exposition of the Distinctcount function

2. The other post you shared did the job and helped me complete my task correctly.

Thaks a lot!

[harshnathani · Accepted solution]

HI @Panta ,

Please see if this video helps

https://www.youtube.com/watch?v=KeapGs-VTYI

https://community.powerbi.com/t5/Desktop/Related-Distinct-Count/m-p/362302

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)