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 shoul...
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

     

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