Nested If | Measures as Rows

[ovetteabejuela]

This is working for me:

Values (Home) = IF(NOT(ISBLANK([A Measure])) && HASONEVALUE('Home'[Measures]),
SWITCH (
LASTNONBLANK ( 'Home'[Measures], 1 ),
"Metric Name 1", [Measure Calc 1],
"Metric Name 2", [Measure Calc 2],
"Metric Name 3", [Measure Calc 3],
"Metric Name 4", [Measure Calc 4],
))

EDIT: I am not sure if I'm asking the right questions but based above is there anyway I could check the value of another filter and toggle Metric Name 3 to show/hide?

However I wanted more, the situation... There is one metric in there say "Metric Name 3" that should only appear based on another filter, lets name that filter as TableX[Toggle Show Metric Name 3], so I was wondering if I can do something like this

Values (Home) = IF(NOT(ISBLANK([A Measure])) && HASONEVALUE('Home'[Measures]),
SWITCH (
     LASTNONBLANK ( 'Home'[Measures], 1 ),
          "Metric Name 1", [Measure Calc 1],
          "Metric Name 2", [Measure Calc 2],
          IF(HASONEVALUE(tableX[Toggle Show metric 3])
                 "Metric Name 3", [Measure Calc 3],
           )          "Metric Name 4", [Measure Calc 4],
))

Is this even possible, if not would you have a suggestion?

EDIT: Not usre if I'm asking the right question, let me rephrase... bsaed on the scenario above is there a way to check the value of another filter and based on what's selected toggle Metric Name 3 to show/hide? 

[v-ljerr-msft]

Hi @ovetteabejuela,

Have you tried the solution provided above? Does it work in your scenario? 

If you still have any question on this issue, feel free to post here.

Regards

[v-ljerr-msft]

Hi @ovetteabejuela,

If I understand you correctly, instead of adding the logic within the SWITCH function, you should rewrite [Measure Calc 3] or just create a new measure for "Metric Name 3" to add this new logic for toggling Metric Name 3 to show/hide with another filter. 

New Measure Calc 3 = IF ( HASONEVALUE ( tableX[Toggle Show metric 3] ), [Measure Calc 3], BLANK () )

Values (Home) = IF(NOT(ISBLANK([A Measure])) && HASONEVALUE('Home'[Measures]),
SWITCH (
LASTNONBLANK ( 'Home'[Measures], 1 ),
"Metric Name 1", [Measure Calc 1],
"Metric Name 2", [Measure Calc 2],
"Metric Name 3", [New Measure Calc 3],
"Metric Name 4", [Measure Calc 4],
))

Regards

[bblais]

Can you move the IF into the expression of the SWITCH instead?

Values (Home) = IF(NOT(ISBLANK([A Measure])) && HASONEVALUE('Home'[Measures]),
SWITCH (
        IF(HASONEVALUE(tableX[Toggle Show metric 3]),
           "Metric Name 3",
           LASTNONBLANK ( 'Home'[Measures], 1 )
           ),
           "Metric Name 1", [Measure Calc 1],
           "Metric Name 2", [Measure Calc 2],
           "Metric Name 3", [Measure Calc 3],
           "Metric Name 4", [Measure Calc 4],
))