Forum Discussion

Oded-Dror's avatar
Oded-Dror
Helper III
4 years ago
Solved

Dynamic value in calculated column

Hi there, Please take a look at this picture (AdventureWorksDW) And tell me if this is possible to store value in calculated column based on dynamic value from a measure. I've try (see my code) bu...
Need Help
  • jeroendekk's avatar
    jeroendekk
    4 years ago

    Hi Oded-Dror 
    Calculated columns and tables are calculated on refresh and after that they are static.

     

    So a slicers will impact which rows of a table are used but not the content itself. A measure could create this result, but you cannot use measure results in a slicer.

    So sorry I do not think this is possible.

    Best regards,

    Jeroen Dekker

Kumail's avatar
Kumail
Impactful Individual
4 years ago

Hello Oded-Dror 

 

If you could send a sample .pbix that demonstrates what you are looking to get. It would really help to provide you with a quick solution.

 

Regards
Kumail Raza