Forum Discussion

lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
3 years ago

Return different measure for different values

Hi everyone,

 

i have a KRI Dimension table, like this:
KRI_01
KRI_02
KRI_03

for each of my KRI i have a different Measure that calculate its status from different facts tables.
KRI_01_Status
KRI_02_Status
KRI_03_Status

Now i create a Measure that SWITCH for each KRI and return the relative measure.

SWITCH(
            MAX('KRI'[ID KRI])
            ,"KRI_01", [KRI_01_Status]
            ,"KRI_02", [KRI_02_Status]
            ,"KRI_03", [KRI_03_Status]
            ,BLANK()
)


There is a way to write a measure that automatically select for every KRI the relative KRI_n Status?
That works for example also for a new KRI_04 with the relative measure KRI_04 Status?

Thank you for your support!

2 Replies