Filter by sum of group by if duplicates

[slyfox]

Dear Community,

I have a flat table 

Column 1	Column 2	Column Uniq	Column Value 1	Column Value 2	Formula	Expected Result
aaaa	1111	aaaa1111	100	12	100/(12+3)*12	80
aaaa	1111	aaaa1111	100	3	100/(12+3)*3	20
bbbb	2222	bbbb2222	200	5	100/5*5	100

What formula can be used to receive expected result ?

[Zubair_Muhammad · Accepted solution]

Hi @slyfox 

Try this column

Column =
DIVIDE (
    [Column Value 1] * [Column Value 2],
    CALCULATE (
        SUM ( TableName[Column Value 2] ),
        ALLEXCEPT ( TableName, TableName[Column 1] )
    )
)