Forum Discussion
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...
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]))
Hi,
how large is your table?
And how does the Dim Shops table relate to the Fact Transaction table?
Have you tried it without Filter?
Calculate ( distinctount('Dim Shops'[Shop]); Fact Transactions'[Amount] > 0 )
The Transactions Table has about 60 Mio entries, The Trans_Aggregate Table which relates to the Shops Table has about 20 Mio Entries.
The formula returns a false - every article has the same distribution then - value without filter. This does not work unfortunately