I want to calculate weighted percent

[gizempekk]

I want to multiplication 50*1+30*0+20*0 for "İş ve Özel Hayat Dengesi" and make similar thing to all rows

[gizempekk]

Like this

[Icey · Accepted solution]

Hi @gizempekk ,

How about this?

Measure 1 = 
SUM ( Reasons[Value] ) * SUM ( 'Percent'[Percent] )

Measure 2 = 
SUMX ( VALUES ( 'Percent'[Point] ), [Measure 1] )

Measure 3 = 
VAR All_Sum =
    SUMX ( ALL ( ReasonOrder ), [Measure 2] )
VAR Divide_ =
    ROUND ( DIVIDE ( [Measure 2], All_Sum ), 4 )
RETURN
    IF (
        HASONEVALUE ( 'Percent'[Point] ),
        SUM ( Reasons[Value] ),
        [Measure 2] & " / " & Divide_ * 100 & "%"
    )

For more details, please check the attached .pbix file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.