topic Re: Dax to Sum Rows in DAX Commands and Tips

Dax to Sum Rows

kunal_mehta1 — Wed, 05 Apr 2023 03:24:16 GMT

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.

Re: Dax to Sum Rows

FreemanZ — Wed, 05 Apr 2023 03:32:28 GMT

hi kunal_mehta1

try like:

measure =

CALCULATE(

SUM(TableName[Dollar]),

TableName[ProjectNumber] IN {"A1", "B1"}

)

Re: Dax to Sum Rows

Jihwan_Kim — Wed, 05 Apr 2023 03:35:48 GMT

Hi,

I am not sure how your expected outcome of a visualization looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Re: Dax to Sum Rows

kunal_mehta1 — Wed, 05 Apr 2023 03:56:49 GMT

Sorry, i would like to elaborate a little.
I have projects with C number and out of those C projects i have few O projects with the same last 4 digits.
I want to sum the dollar values of C and O for that particular project with same last 4 digits.
I want a measure which would sum the C and O rows with same last 4 digits and if it doesn't have the O number just give the value of C number row.
I hope that this makes it clear.

Re: Dax to Sum Rows

FreemanZ — Wed, 05 Apr 2023 04:09:37 GMT

kunal_mehta1

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

Re: Dax to Sum Rows

kunal_mehta1 — Wed, 05 Apr 2023 04:35:08 GMT

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.

Re: Dax to Sum Rows

v-zhangti — Tue, 18 Apr 2023 07:37:15 GMT

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.