Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable

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

      • lbendlin's avatar
        lbendlin
        Super 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.