DAX Patterns: Related distinct count
This is an in-depth video lecture of the
pattern. Related distinct count
This pattern is useful whenever you have one or more fact tables related to a dimension, and you need to perform the distinct count of column values in a dimension table only considering items related to transactions in the fact table. For demonstration purposes we use the distinct count of the product name where the same product name can have different produce codes in a model with two fact tables:
Sales and Receipts. Collection
Student Reviews (11)
Arend Dik (Jan 22, 2022) A practical example, thanks. Roger Van Decraen (Oct 21, 2021) as always very clear and instructive
Roger Juan Carlos Navarrete López (Apr 10, 2021) Excellent, it is very useful in practice, Thank you so much Gajanand Tiwari (Feb 10, 2021) Good Claudio Trombini (Feb 5, 2021) N.1 Rigoberto Garcia (Jan 6, 2021) Great. Thanks Joao Monteiro (Oct 28, 2020) Exceptional.
Very clear and very useful.
Thank you very much. Kamil Kwiatkowski (Oct 2, 2020) Clearly explained. Raul Callejon Lopez (Sep 19, 2020) Very useful! Mark A Baich (Aug 25, 2020) Fantastic explanation! Jimco Van Elteren (Aug 17, 2020) Powerful!
What is included
This video course contains 12 minutes of training, for a total of 2 lectures.
Our training platform
tracks your progress and resumes the course from where you left off.
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!