Return different measure for different values

[lucadelicio]

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!

[amitchandak]

@lucadelicio , With an Axis/Row, you can change measures using field parameters.

example 

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

Learn Power BI: Changing measures based on the axis with Field Parameters in Power BI. Dynamic measures based on the axis/Dimension: https://youtu.be/7ikRAelDph0

[lucadelicio]

Thank you for your Answer, but i don't want to switch the DIM.
With the same DIM i want to return different measure for each value of my DIM.
Thank you for your support!