Forum Discussion

Jayshamone's avatar
Jayshamone
Helper 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
    5 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]))

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Jayshamone ,

 

This formula is not complicated, it seems that there is no room for improvement.

The following reasons may cause the query to be too slow:

1. The dataset is too large.

2. Connection mode.

What's your connection mode?

The time that's needed to refresh the visualization depends on the performance of the underlying data source if you are using 'DirectQuery'.

3. The local computer configuration is too low.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.