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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , a new column

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

 

a measure

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Can i apply a filter to the first value? 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

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

  • 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.