cancel
Showing results for
Did you mean:
Highlighted
Responsive Resident

## Incorrect total

hi, I know this is a classic problem that can be resolved with SUMX, but somehow, I couldn't get it done.

Here is the file:

https://1drv.ms/x/s!Aps8poidQa5zk5NCkQV_1tDZcbThRQ

I can't match the total as below:

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: Incorrect total

@Iamnvt

In a single step, you can do like this

But i think better to create a second measure like in the earlier post

```Demand in LT =
IF (
HASONEFILTER ( LT[Mat] ),
SUMX (
VALUES ( LT[Mat] ),
VAR newLT =
SUMX ( LT, LT[LT] )
VAR filtertable =
FILTER (
ALL ( 'Calendar' ),
'Calendar'[Date] >= TODAY ()
&& 'Calendar'[Date] - TODAY ()
<= newLT
)
RETURN
CALCULATE ( SUM ( Demand[Demand] ), filtertable )
),
SUMX (
VALUES ( LT[Mat] ),
CALCULATE (
SUMX (
VALUES ( LT[Mat] ),
VAR newLT =
SUMX ( LT, LT[LT] )
VAR filtertable =
FILTER (
ALL ( 'Calendar' ),
'Calendar'[Date] >= TODAY ()
&& 'Calendar'[Date] - TODAY ()
<= newLT
)
RETURN
CALCULATE ( SUM ( Demand[Demand] ), filtertable )
)
)
)
)
```
Try my new Power BI game Cross the River
3 REPLIES 3
Super User III

## Re: Incorrect total

@Iamnvt

You can use this MEASURE

```Measure =
IF (
HASONEFILTER ( LT[Mat] ),
[Demand in LT],
SUMX ( VALUES ( LT[Mat] ), [Demand in LT] )
)
```
Try my new Power BI game Cross the River
Responsive Resident

## Re: Incorrect total

thanks for the solution.

How can I combine the two measures: [Demand in LT], and [Measure 1] into 1 measure only?

I tried to put the same formula of [Demand in LT] into [Measure 1], but it didn't give the correct result.

Thanks

Super User III

## Re: Incorrect total

@Iamnvt

In a single step, you can do like this

But i think better to create a second measure like in the earlier post

```Demand in LT =
IF (
HASONEFILTER ( LT[Mat] ),
SUMX (
VALUES ( LT[Mat] ),
VAR newLT =
SUMX ( LT, LT[LT] )
VAR filtertable =
FILTER (
ALL ( 'Calendar' ),
'Calendar'[Date] >= TODAY ()
&& 'Calendar'[Date] - TODAY ()
<= newLT
)
RETURN
CALCULATE ( SUM ( Demand[Demand] ), filtertable )
),
SUMX (
VALUES ( LT[Mat] ),
CALCULATE (
SUMX (
VALUES ( LT[Mat] ),
VAR newLT =
SUMX ( LT, LT[LT] )
VAR filtertable =
FILTER (
ALL ( 'Calendar' ),
'Calendar'[Date] >= TODAY ()
&& 'Calendar'[Date] - TODAY ()
<= newLT
)
RETURN
CALCULATE ( SUM ( Demand[Demand] ), filtertable )
)
)
)
)
```
Try my new Power BI game Cross the River

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors