Forum Discussion

kunal_mehta1's avatar
kunal_mehta1
Icon for Helper I rankHelper 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.

kunal_mehta1's avatar
kunal_mehta1
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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.