Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
raymond
Post Patron
Post Patron

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:

2018-12-03 09_00_10-Little Test - Excel.png

2 ACCEPTED SOLUTIONS
v-juanli-msft
Community Support
Community Support

Hi @raymond

Create a measure

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

1.png

 

Best Regards

Maggie

View solution in original post

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.

8.png

 

Best Regards

Maggie

 

View solution in original post

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi @raymond

Create a measure

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

1.png

 

Best Regards

Maggie

@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?

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.

8.png

 

Best Regards

Maggie

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.