divide row by column total for each set of values

[Anonymous]

Hello hope you can help me.

I am trying to create a measure that looks into the quantity (tbwght) for each row and divides it by the total quantity (tbwght) for all the rows - in the example  1120. This has to be automatically done for different set selections of tbinvrel - first column. Can you kindly help

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You could get it just by this formula

Measure =
DIVIDE (
    [tbwght],
    CALCULATE (
        [tbwght],
        FILTER ( ALLSELECTED ( 'Table' ), Table[tbinvrel] = MAX ( Table[tbinvrel] ) )
    )
)

Best Regards,

Lin