Measure written as text string in a lookup table?

[Marcuskwil]

I'm creating a lookup table to write measures/definitions of multiple KPI, I intend to do this to avoid creating many Measures and instead filtering a visual on the selected KPI.

"Formula" just returns the text string, is there a way in which I can get Power BI to evaluate the expression returned by the Variable?

[Anonymous]

@Marcuskwil 

Such things are not possible. DAX does not calculate formulas dynamically. The closest you could arrive at is CALCULATION GROUPS but still, they are not dynamic formulas in the sense you'd like them to be.

[Marcuskwil]

I think I've managed to create a flexible workaround.
First I created a table with the KPI's I want to have available with their respective transformation:

Then I'm able to use a Switch to jump between the different Transformation logics:

That way I'm able to have 1 measure for all the visuals and then filter the respective visual on the KPI I want.

[Anonymous]

@Marcuskwil 

This is the standard way to obtain a measure that will be returning different measures depending on choices. Nothing to do with the dynamic behavior you wanted 🙂 If you had asked your question in a different way, someone would most likely have given you this very pattern.

[amitchandak]

@Marcuskwil , You should explore calculation group for that

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

https://www.youtube.com/watch?v=vlnx7QUVYME