cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Sum Dax help

Hi all,

Here is scenario wherein we have to calculate the sum based on two condition of the same column and then multiple with the sum of another column and eventually add up the total for a particular quarter i.e.

For 1st section the hours total would be 181 and load for that travel would be 2000. The total work is 181 * 2000 =362000. in similar fashion for each start and stop point for each bus

Now we have to calculate the sum for each start and till halt stop point for each bus and same goes for each cargo. then we would need to multiply the sum of hrs and some of cargo for that start till halt point for that voyage

2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft

## Re: Sum Dax help

Hi @Anonymous

You may try to add a group column and then you may get the measures.Please check the attached file.

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User IV

## Re: sum dax help

So, for something like this you are going to need some kind of identifier for "grouping" to occur. For example, your first 3 rows should be 1 and then your next 6 rows should be 2, etc. because they all belong together. You might find my work on Cthulhu of use.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

7 REPLIES 7
Highlighted
Anonymous
Not applicable

## sum values between two criteria

Hi all,

Here is scenario wherein we have to calculate the sum based on two condition of the same column and then multiple with the sum of another column and eventually add up the total for a particular quarter i.e.

For 1st section the hours total would be 181 and load for that travel would be 2000. The total work is 181 * 2000 =362000. in similar fashion for each start and stop point for each bus

Now we have to calculate the sum for each start and till halt stop point for each bus and same goes for each cargo. then we would need to multiply the sum of hrs and some of cargo for that start till halt point for that voyage

Anonymous
Not applicable

## sum dax help

Hi all,

Here is scenario wherein we have to calculate the sum based on two condition of the same column and then multiple with the sum of another column and eventually add up the total for a particular quarter i.e.

For 1st section the hours total would be 181 and load for that travel would be 2000. The total work is 181 * 2000 =362000. in similar fashion for each start and stop point for each bus

Now we have to calculate the sum for each start and till halt stop point for each bus and same goes for each cargo. then we would need to multiply the sum of hrs and some of cargo for that start till halt point for that voyage

Super User IV

## Re: sum dax help

So, for something like this you are going to need some kind of identifier for "grouping" to occur. For example, your first 3 rows should be 1 and then your next 6 rows should be 2, etc. because they all belong together. You might find my work on Cthulhu of use.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Microsoft

## Re: Sum Dax help

Hi @Anonymous

You may try to add a group column and then you may get the measures.Please check the attached file.

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

## Re: sum dax help

@Greg_Deckler- You are awesome , thanks so much for the help

Anonymous
Not applicable

## Re: Sum Dax help

Thanks so much for the help u guys are super cool , this community is very very helpful:)

Anonymous
Not applicable

## Re: Sum Dax help

@v-cherch-msft  - Thanks so much for the help u guys are super cool , this community is very very helpful

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!