Forum Discussion

kunal_mehta1's avatar
kunal_mehta1
Helper I
3 years ago
Solved

Dax to Sum Rows

Hi All, I want to have dax expression for power BI to sum multiple rows. I want a measure which would sum the dollar value of A1 and dollar value of B1 and give me a total of 30. Thanks.
"Need Help"
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, kunal_mehta1 

     

    You can try the following methods.
    Column:

    Number = RIGHT([Project Number],4)

    Measure = CALCULATE(SUM('Table'[Dollar]),ALLEXCEPT('Table','Table'[Number]))

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

FreemanZ's avatar
FreemanZ
Super User
3 years ago

kunal_mehta1 

could you also provide directly your expected result based on the sampledata?

kunal_mehta1's avatar
kunal_mehta1
Helper I
3 years ago

It would be a measure which will give me sum of dollar vlaue for C7097 and O7097 which would be 30 , next gives me sum of C7088 and O7088 which would be 35, also gives me the value of C7086 even if it doesn't have O number which would be 25.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, kunal_mehta1 

     

    You can try the following methods.
    Column:

    Number = RIGHT([Project Number],4)

    Measure = CALCULATE(SUM('Table'[Dollar]),ALLEXCEPT('Table','Table'[Number]))

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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