SWITCH function with two columns

[MariaFlorenciaB]

hi everyone, I need help with a formula that I think should use Switch function.

I have this table (Jerarquia de medidas)

Level 1	Level 2
TON
GSV
OFF	Tactic
OFF	Manual
OFF	Tax

And I have in my data base, a formula for each measure: a formula for OFF, TON, GSV, Tactic, Manual and Tax.

So I need a formula that brings for each level,  the corect formula.

So, I developed this:

Formula=

VAR KpiList2= SELECTEDVALUE('Jerarquia Medidas'[Level 2])

VAR KpiList1= SELECTEDVALUE('Jerarquia Medidas'[Level 1])

RETURN

SWITCH(KpiList2;

"Manual";[Manual]

;"Tactic";[TACTICO]

;"Tax";[Tax]

)

&&

SWITCH(KpiList1;

"TON";[TON]

;"GSV";[GSV Factura])

The problem is that when I create a table with Level 1 and Level 2 and use this formula, it brings only True and False.

Any ideas???

Thanks!!!!

[Mariusz · Accepted solution]

Hi @MariaFlorenciaB 

Try this

Formula = 
VAR KpiList2 = SELECTEDVALUE('Jerarquia Medidas'[Level 2])
VAR KpiList1 = SELECTEDVALUE('Jerarquia Medidas'[Level 1])
RETURN
SWITCH(
    KpiList1;
    "TON"; [TON];
    "GSV"; [GSV Factura];
    SWITCH(
        KpiList2;
        "Manual"; [Manual];
        "Tactic"; [TACTICO];
        "Tax"; [Tax]
    )
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MariaFlorenciaB]

@Mariusz Sorry, I only have one problem:

If I add the line OFF to the formula:

Formula = 
VAR KpiList2 = SELECTEDVALUE('Jerarquia Medidas'[Level 2])
VAR KpiList1 = SELECTEDVALUE('Jerarquia Medidas'[Level 1])
RETURN
SWITCH(
    KpiList1;
    "TON"; [TON];
    "GSV"; [GSV Factura];
    "OFF"; [OFF];
    SWITCH(
        KpiList2;
        "Manual"; [Manual];
        "Tactic"; [TACTICO];
        "Tax"; [Tax]
    )
)

 I only see the total number of OFF for the measure OFF and for the measures Manual, Tactic and Tax.

Do you know why this happens?

[MariaFlorenciaB]

Thanks very much @Mariusz !!