Distinct Count of Customers in a SCD Type 2 in #DAXhttp://sqlblog.com/blogs/marco_russo/archive/2012/04/09/distinct-count-of-customers-in-a-scd-type-2-in-dax.aspxIf you have a Slowly Changing Dimension (SCD) Type 2 for your customer and you want to calculate the number of distinct customers that bought a product, you cannot use the simple formula: Customers := DISTINCTCOUNT( FactTable[Customer Id] ) ) becauseenCommunityServer 2.1 SP2 (Build: 61129.1)