DAX Help, why are the changed values not totalling properly?

[Ttaylor9870]

Hi Everyone,

I have been scratching my head about a problem I'm currently having,

When I change a columns value the total will not display the correct total it still counts the total as if the old values were still present.

I've went and made some dummy example data if soomeone could help me and below is an example of the table I am trying to build...

Relationship has be be like this because this is just a sample from the table columns that I've needed.

I need to do: Total Outstanding Quantity -  Total Quantity

And then assign all negative values from this equation to zeros, then multiply this equation by the Selling price.

Here are my Tables...

Item No	Quantity
1	5
2	10
3	8
4	35
5	6
6	15
7	16
8	17
9	18
10	19

No	Selling Selling Price	Prod Group
1	5	AAA
2	6	BBB
3	7	CCC
4	8	DDD
5	9	EEE

No	Outstanding Quantity	Location Code
1	10	OOOOOO
2	20	LLLLLLLLLL
3	30	MMMMMM
4	40	PPPPPPPPPP
5	3	SSSSSSSSSSS
6	8	GGGGGGGGGG
7	9	FFFFFFFFFF
8	3	BBBBBBBBB
9	5	NNNNNNNNN
10	6	SSSSSSSSSSS

Many Thanks,

Taylor

[tamerj1 · Accepted solution]

Hi @Ttaylor9870 
You need to iterate the products

Result =
SUMX (
    Nav_Item,
    VAR CurrentItemPrice = Nav_Item[Selling Price]
    VAR DifferenceValue = [Total Outstanding Quantity] - [Total Quantity]
    RETURN
        IF ( DifferenceValue > 0, DifferenceValue * CurrentItemPrice )
)