Forum Discussion

Specialist707's avatar
Specialist707
Frequent Visitor
3 years ago
Solved

Dynamically Average Selected Field Parameters in Bar Chart

Hi,   I'm working on a project where there are numerous inputs, which are then averaged together to come up with a composite score. I would like the ability to be able to select various combination...
DAX
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Specialist707 ,

     

    Please try:

    Composite Score =
AVERAGEX (
    'Parameter',
    SWITCH (
        CALCULATE ( MAX ( 'Parameter'[Parameter] ) ),
        "Input 1 rating", [Input 1 rating],
        "Input 2 rating", [Input 2 rating],
        "Input 3 rating", [Input 3 rating]
    )
)

    Final output:

     

    Best Regards,

    Jianbo Li

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

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Specialist707 ,

 

Please try:

Composite Score =
AVERAGEX (
    'Parameter',
    SWITCH (
        CALCULATE ( MAX ( 'Parameter'[Parameter] ) ),
        "Input 1 rating", [Input 1 rating],
        "Input 2 rating", [Input 2 rating],
        "Input 3 rating", [Input 3 rating]
    )
)

Final output:

 

Best Regards,

Jianbo Li

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