Divide every row with a total

[Anonymous]

Hi guys,

need help to divide every row with a total. Is SUMX the rifht function to do it? Tried it with calculate Sumx divided by calculate sum and it did not work. Anyone an idea?

Thank You 

[Anonymous]

Hello @Anonymous 

Hope this helps 

Create a measure for total Sum = 

Sum = Sum(Table[Column])

Create a column = Divide(Table[column], Sum)

Thank you

[amitchandak]

@Anonymous , a new column

Percent = divide([value], sum(Table[Value]))

a measure

Percent = divide(sum(Table[value]), calculate(sum(Table[Value]), allselected(Table)))

[Anonymous]

Can i apply a filter to the first value? 

[v-jingzhang]

Hi @Anonymous

If you want to apply a filter, you need to use a measure. See the difference between the following two measures.

Percent = DIVIDE(SUM('Table'[Value]), CALCULATE(SUM('Table'[Value]), ALLSELECTED('Table')))


Percent 2 = DIVIDE(SUM('Table'[Value]), CALCULATE(SUM('Table'[Value]), ALL('Table')))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Anonymous , No, if you want to pass slicer value. you need use measure for that, second one