DAX Patterns: Related distinct count
This is an in-depth video lecture of the Related distinct count pattern.
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.
Collapse allCurriculum
Collection
- Rigoberto Garcia (Nov 8, 2024)
Excellent readings, complemented by a very explanatory video, with which you can follow the step by step, complete the exercise and clearly understand what is presented. I highly recommend viewing and studying it. Many thanks to sqlbi for sharing these lessons, which have a positive impact on our professional training.
- Krum Slavchev (Jul 4, 2024)
another concise and precise video
- Genadiy Tsvetkov (Dec 24, 2023)
great!
- gianluca fuscoletti (Sep 10, 2023)
Perfetto! era quello che cercavo da giorni! grazie siete sempre il mio riferimento preferito per il dax!
- Emir Tutan (Aug 20, 2023)
Great!
- Rafal Staniewski (Jun 10, 2023)
Very good instruction!
- Arend Dik (Jan 22, 2022)
A practical example, thanks.
- Roger Van Decraen (Oct 21, 2021)
as always very clear and instructive thanks 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!