Forum Discussion

Ronald123's avatar
Ronald123
Icon for Resolver III rankResolver III
3 years ago
Solved

Switching Calculation with Field Parameters in Power BI Visuals

Hey Power BI community, I've noticed that since 2022, there's an option in Power BI to switch between calculations using field parameters. However, I'm currently working on a visual where I want...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Ronald123 ,

     

    Redo the measure to:

    Total Sum = 
VAR _a =
    SELECTCOLUMNS ( Parameter, "Name",[Parameter])
RETURN
    SUMX (
        _a,
        SWITCH (
            [Name],
            "APPEL", [APPEL],
            "ORANGE", [ORANGE],
            "BANANA", [BANANA],
            0
        )
    )

     

    I added a new row Banana to get some different results but it's working has needed:

     

     

     

Ronald123's avatar
Ronald123
Icon for Resolver III rankResolver III
3 years ago

Hello Miguel Félix,

Thank you for your response.

When I use the formula now (the 1st option), there is no total when I select 2 parameters at the same time. Can you help me modify the formula so that it adds Calculation A and Calculation B together?

Best regards,

Ronald

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Ronald123 ,

     

    the google link is asking for a password.

    • Ronald123's avatar
      Ronald123
      Icon for Resolver III rankResolver III
      2 years ago

      Hi MFelix ,

      The test file can now be accessed without a password.

      Greets,

      Ronald

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        2 years ago

        Hi Ronald123 ,

         

        Redo the measure to:

        Total Sum = 
VAR _a =
    SELECTCOLUMNS ( Parameter, "Name",[Parameter])
RETURN
    SUMX (
        _a,
        SWITCH (
            [Name],
            "APPEL", [APPEL],
            "ORANGE", [ORANGE],
            "BANANA", [BANANA],
            0
        )
    )

         

        I added a new row Banana to get some different results but it's working has needed: