Forum Discussion

afrutos's avatar
afrutos
Icon for Resolver I rankResolver I
4 years ago
Solved

Formula Switch

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 ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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]
    )

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
afrutos
Icon for Resolver I rankResolver I
4 years ago

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's avatar
    ALLUREAN
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Remove one of the double brackets

    • afrutos's avatar
      afrutos
      Icon for Resolver I rankResolver I
      4 years ago

      I modifyed it,  but still have the same text error

       

      • Samarth_18's avatar
        Samarth_18
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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]
)