calculation

[razan_5r5]

how i can sum all the value in one column except one in power bi 

[Anonymous]

Hi, 

you can use 

CALCULATE(sum(Table1[cost]), ALLEXCEPT(Table1,Table1[city ]))

Hope it will help you.

Please mark it as solution if you got your answer

[Anonymous]

Hi  @razan_5r5 ,

I created some data:

Add [amount1] and [amount2]

Here are the steps you can follow：

Create calculated column.

Sum_Column = 'Table'[amount1] + 'Table'[amount2]

Create measure.

Sum_Measure = SUM('Table'[amount1])+SUM('Table'[amount2])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[GilbertQ · Accepted solution]

Hi @razan_5r5 

If you mean all except on column you could do use the DAX measure ALLEXECPT

ALLEXCEPT – DAX Guide

Otherwise if you are looking to filter out on particular value, you could use the FILTER measure

FILTER - DAX Guide