Forum Discussion

raymond's avatar
raymond
Post Patron
7 years ago
Solved

Weighted Values

Dear Community,

 

I want to calculate a simple weighted value. 

The total and filter resistant sum a value should be divided by the total and filter resistant sum of weight. Next this number should be multiplied with the target variable by row.

 

See the Image:

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi raymond

    Create a measure

    final_output =
DIVIDE (
    CALCULATE ( SUM ( Sheet2[value] ), ALL ( Sheet2 ) ),
    CALCULATE ( SUM ( Sheet2[weight] ), ALL ( Sheet2 ) )
)
    * MAX ( [weight] )

     

    Best Regards

    Maggie

  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi raymond

    I didn't realize the column "weight value" is what you want until now.

    to get the same value as  "weight value" , you could set the date format of "final_output" as below.

     

    Best Regards

    Maggie

     

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi raymond

    Create a measure

    final_output =
DIVIDE (
    CALCULATE ( SUM ( Sheet2[value] ), ALL ( Sheet2 ) ),
    CALCULATE ( SUM ( Sheet2[weight] ), ALL ( Sheet2 ) )
)
    * MAX ( [weight] )

     

    Best Regards

    Maggie

    • raymond's avatar
      raymond
      Post Patron
      7 years ago

      v-juanli-msft Thanks for getting back to me. 

      One question. What is the difference between the column "weight value" and "final_output"? If there is a calculation for the first, could you share that as well?

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi raymond

        I didn't realize the column "weight value" is what you want until now.

        to get the same value as  "weight value" , you could set the date format of "final_output" as below.

         

        Best Regards

        Maggie