Forum Discussion

Jayshamone's avatar
Jayshamone
Icon for Helper I rankHelper I
6 years ago
Solved

DAX Article Distribution

Hello, I am trying to calculate the distribution of articles (or article groups) in a dynamic timespan. Currently I am using a DAX Statement which underperforms massively with a large number of a...
Need Help
  • Jayshamone's avatar
    Jayshamone
    6 years ago

    Thanks for your help.
    However, I found a formula that calculates the correct result in far less time.
    It goes like this:

    CALCULATE (DISTINCTCOUNT('Dim Shops'[Shop]); VALUES([Fact Transactions]))