Forum Discussion
DAX measure - Distinct count referencing second table
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
- Anonymous5 years ago
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)
2 Replies
- AnonymousNot applicable
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) - PantaNew Member
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!