Forum Discussion
Solved
SWITCH
I'm using the following formula to populate a specific column of a table: Limite = SWITCH('Tabella FIP CDA'[ordine];3;[Bond];2;[Corporate]) Tha tabe has 3 colums: ordine( constant numbers from 1 t...
I got the solution bymyself it's enough to use SWITCH(TRUE()
HI Emiliano ,
Did you mean you are try to create a calculated column to use switch to check current row and return measure result?
If this is a case, power bi not support to use slicer/filter to create a dynamic calculated column.
Measure are calculated based on its row contents, if you use it in calculated column. Its row contents will be fixed as whole table and return static result.
Regards,
Xiaoxin Sheng
The measures are calculated outside table with data outside the table but they are only put in the table in each rows with function SWITCH (each row has a different measure) and they have to change with time filter but the don't.