Forum Discussion

lizzy's avatar
lizzy
Helper I
5 years ago
Solved

Dynamic Weighted Sum

I'm trying to create a dynamic weighted sum of different attributies of categories to get a total using user-adjustable parameters.
My component table looks something like this:

CategoriesValue1Value2
Cat10.30.4
Cat20.10.7
Cat30.60.3

Then I have two what-if parameters, Parameter1 and Parameter2.
I want to create a measure that allows me to get Value1*Parameter1+Value2*Parameter2 for each category.

I tried to use a calculated column, but apparently calculated columns don't work with what-if parameters. Is there a way to create a measure that looks like this?

CategoriesOutput
Cat10.3*Parameter1+0.4*Parameter2
Cat20.1*Parameter1+0.7*Parameter2
Cat30.6*Parameter1+0.3*Parameter2
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    lizzy 

    You can try this meaure:

    Output
    = IF (
        HASONEVALUE ( table[Categories] ),
        SUM ( table[value1] ) * SELECTEDVALUE ( 'Parameter1'[value] )
            + SUM ( table[value2] ) * SELECTEDVALUE ( 'Parameter2'[value] )
    )

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    lizzy 

    You can try this meaure:

    Output
    = IF (
        HASONEVALUE ( table[Categories] ),
        SUM ( table[value1] ) * SELECTEDVALUE ( 'Parameter1'[value] )
            + SUM ( table[value2] ) * SELECTEDVALUE ( 'Parameter2'[value] )
    )