Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |