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

Ttaylor9870 — Mon, 16 Jan 2023 12:28:30 GMT

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

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

tamerj1 — Mon, 16 Jan 2023 12:41:30 GMT

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 ) )

topic DAX Help, why are the changed values not totalling properly? in DAX Commands and Tips

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

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