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

     

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