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
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: