I have MDX that generates the correct results in the example below, but it is extremely slow.
I can achieve this through filtering, but with the amount of data it is extremely slow. Is there a function or another way to write MDX other than filter to achieve this?
STR1 10 100
STR2 20 150
STR5 30 100
= Sum of BRD / Sum of Totals where BRD is not null
= 60/350 = 17.14
View Complete Post