Forum Discussion
Anonymous
3 years agoNot applicable
Simple formula
Hello,
I created this formula but the formula is to heavy and takes 5 min to load the value into a table.
The principle is simple: it takes the YTG value filtered to each account i need.
there is a measure [YTG Values] and another one [Account].
Is there a simpliest way to compute it ?
Best regards.
A.K
3 Replies
- lbendlinSuper User
Read about SUMMARIZE - much easier and much faster.
- AnonymousNot applicable
I am not trying to create a new table, thanks for your help
- lbendlinSuper User
You can use table variables during the computation of your measure. You will need to return a scalar value at the end but that can be achieved with a SUMX over the table variable created by SUMMARIZE.