cancel
Showing results for
Did you mean:
Regular Visitor

## DAX subtraction formula without summing up when there are multiple entries of the same category

Hello everyone,

I have a formula which does a basic subtraction:

the max load length is the capacity and ldm is the load  with one row being one truck/drive. Now there can be multiple routes a day for the same truck when its a short route, meaning the truck 5 could exist 3 times. In this case the formula sums the values of those 3 entries and subtracts it. I don't want this even if it exists multiple times I still want it to only do it for that specific truck. I think i need to convert this to a calculated column to avoid the summing up when there are multiple entries of the same category.
example of data:
5           10                                5
5           10                                3
5           10                                2

In the current situation the result would be:
Truck   |  FREE LDM
5              20

I want it to be like this
Truck  |   FREE LDM
5                5
5                7
5                8
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

## Re: DAX subtraction formula without summing up when there are multiple entries of the same category

Hi @Johnlogistic ,
Your issue may be as easy as checking Don't Summarize, by clicking on the fields that you are bringing in. See pics. I also did another measure that you might use, although I think yours is fine. Measures are superior to doing a calculated column.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

``````MAX_LOAD_LENGTH minus LDM 1 =

Proud to be a Super User!

Highlighted
Super User IV

## Re: DAX subtraction formula without summing up when there are multiple entries of the same category

Hi @Johnlogistic ,
Your issue may be as easy as checking Don't Summarize, by clicking on the fields that you are bringing in. See pics. I also did another measure that you might use, although I think yours is fine. Measures are superior to doing a calculated column.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

``````MAX_LOAD_LENGTH minus LDM 1 =

Proud to be a Super User!

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!