Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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)
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!
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)
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |