Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Panta
New Member

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

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

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)

 

 

View solution in original post

2 REPLIES 2
Panta
New 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!

harshnathani
Community Champion
Community Champion

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)

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.