Accept cookies to show this video. Cookies Policy
Allow all cookies

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

  • Related distinct count

    • About the Related distinct count pattern
    • Pattern description

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
4.9
38 ratings
95%
5%
0%
0%
0%
Student Reviews (15)
  • 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!

  • Mark A Baich (Aug 25, 2020)

    Fantastic explanation!

  • Jimco Van Elteren (Aug 17, 2020)

    Powerful!