Forum Discussion
Solved
%GT and Rank
Hi, I have a requirement of computing for the %GT Value based on Securities in the Base table below and display the Top 3 values. However, when the ranking filter is applied, %GT Value recalcul...
Instead of auto calculation, create a measure instead.
GT Value measure = SUM(yourTable[Value])/CALCULATE(sum(yourTable[Value]),ALL(yourTable))
Instead of auto calculation, create a measure instead.
GT Value measure = SUM(yourTable[Value])/CALCULATE(sum(yourTable[Value]),ALL(yourTable))
thank you.