Formula Switch

[afrutos]

Hello good morning to all,
I have a question about a formula, let's see if someone can help me. Thank you very much

I am trying to create a measure in which, if I select with my selector the Gross Amount, it calculates the Gross Amount, if I select the Net Amount, it calculates the Net Amount and the same if I select the Taxable Base.
When the value of what I have selected is blank, it automatically puts me (Blank), however, I would like it to put "Nothing pending".

With my formula it is not working

This is my formula:

Selección Detalle =

IF(ISCROSSFILTERED(Selector[Selección]),

SWITCH(TRUE(),

ISBLANK(VALUES(Selector[Selección])),"Nada pte",

VALUES(Selector[Selección]) = "Importe Bruto", [Bruto],

VALUES(Selector[Selección]) = "Importe Neto", [Importe Neto],

VALUES(Selector[Selección]) = "Base Imponible", [BI NOBLANK] ,

[BI NOBLANK]),

[BI NOBLANK])

 Thank you in advanced!

[afrutos]

I've made it ut I still have the same problem

[afrutos]

Selección Detalle =

IF(ISCROSSFILTERED(Selector[Selección]),

SWITCH(TRUE(),

ISBLANK(Selector[Selección]),"Nada pte",

Max(Selector[Selección]) = "Importe Bruto", [Bruto],

Max(Selector[Selección]) = "Importe Neto", [Importe Neto],

Max(Selector[Selección]) = "Base Imponible", [BI NOBLANK] ,

[BI NOBLANK]),

[BI NOBLANK])

With this I have the same error

[amitchandak]

@afrutos , try like

SWITCH(TRUE(),
ISBLANK((Selector[Selección])),"Nada pte",
Max(Selector[Selección]) = "Importe Bruto", [Bruto],
Max(Selector[Selección]) = "Importe Neto", [Importe Neto],
Max(Selector[Selección]) = "Base Imponible", [BI NOBLANK] ,
[BI NOBLANK])

[afrutos]

Hi, it gives me an error: A single value cannot be determined for the 'Selection' column in the 'Selector' table. This can happen when a measurement formula refers to a column containing many values without specifying an aggregation, such as min, max, count or sum, to obtain a single result

[ALLUREAN]

Remove one of the double brackets

[afrutos]

I modifyed it,  but still have the same text error

[Samarth_18]

@afrutos Small correction in your code. Please use like this:-

Selección Detalle =
IF (
    ISCROSSFILTERED ( Selector[Selección] ),
    SWITCH (
        TRUE (),
        ISBLANK ( MAX ( Selector[Selección] ) ), "Nada pte",
        MAX ( Selector[Selección] ) = "Importe Bruto", [Bruto],
        MAX ( Selector[Selección] ) = "Importe Neto", [Importe Neto],
        MAX ( Selector[Selección] ) = "Base Imponible", [BI NOBLANK],
        [BI NOBLANK]
    ),
    [BI NOBLANK]
)

[afrutos]

Hi, thank you in advanced.
I made it, but still not working...

This is getting me crazy.

[Samarth_18 · Accepted solution]

@afrutos , can you try to print what is coming inside in  MAX ( Selector[Selección] ) like below just to check whether it is going inside correct condtion or not.

Selección Detalle =
IF (
    ISCROSSFILTERED ( Selector[Selección] ),
    MAX ( Selector[Selección] )
)

or try this:-

Selección Detalle =
VAR selected_value =
    SELECTEDVALUE ( Selector[Selección] )
RETURN
    IF (
        ISCROSSFILTERED ( Selector[Selección] ),
        SWITCH (
            TRUE (),
            ISBLANK ( selected_value ), "Nada pte",
            selected_value = "Importe Bruto", [Bruto],
            selected_value = "Importe Neto", [Importe Neto],
            selected_value = "Base Imponible", [BI NOBLANK],
            [BI NOBLANK]
        ),
        [BI NOBLANK]
    )

[afrutos]

Hi,

Now iw working perfectly, ut I don't understand anything, 
Why is working by defining a variable?

Thank you in advanced