Forum Discussion

Frequent Visitor

7 years ago

Solved

Calculating Normalized Weighted Value

The data looks similar to this: A B C D E F A 1.86 5 9.3 13.5 6.89 A 0 0 0 13.5 0.00 A 0 2 0 13.5 0.00 B 2.4 5 12 13.5 8.89 B 0 0 0 13.5 0.00 B 0 ...

Anonymous

7 years ago

I hope that I understood this correctly

Max Sum Value = 
MAXX(
    SUMMARIZE(
        ALL('Table');
        'Table'[A];
        "Total";SUM('Table'[D])
    );
    [Total]
)

and

Weighted Sum Value = 
DIVIDE(SUM('Table'[D]);[Max Sum Value])*10

Anonymous

Not applicable

7 years ago

I hope that I understood this correctly

Max Sum Value = 
MAXX(
    SUMMARIZE(
        ALL('Table');
        'Table'[A];
        "Total";SUM('Table'[D])
    );
    [Total]
)

and

Weighted Sum Value = 
DIVIDE(SUM('Table'[D]);[Max Sum Value])*10