Forum Discussion
Reusing measure within object
Hi! For comparative analysis I would like to present a table like this: My 4 column measures are fractions, with 4 slightly different but easily calculated numerator background measu...
Thanks, johnt75 !
I found that I can get a similar result by using a matrix table and just the Churn_rate_Total measure if i tweak the common background demoninator measure by adding ALL/REMOVEFILTERS(Churn_types):
CALCULATE(
SUM(.....),
REMOVEFILTERS(Churn_types)
)
The visual result is quite the same, and I would hope that the denominator now only calculates once per segment - or does it still calculate per shown value?
johnt75
Super User
Super UserCertainly from a theoretical point of view you can see that caching would be an option, but I don't know enough about what happens in the background to be able to comment on whether caching would actually happen or not.