Simple formula

[Anonymous]

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

[lbendlin]

Read about SUMMARIZE - much easier and much faster.

[Anonymous]

I am not trying to create a new table, thanks for your help

[lbendlin]

  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.