Distinct Count of Customers in a SCD Type 2 in #DAX
User Rating: 5 / 5
If 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] ) )
Read more...Tags: dax