Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Divide every row with a total

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 
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Can i apply a filter to the first value? 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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.