topic Re: Issue with Measure Total with an IF Statement in DAX Commands and Tips

Issue with Measure Total with an IF Statement

Brad_Roberts — Mon, 12 Dec 2022 21:27:06 GMT

After reading many posts on this i'm still having issues with the total for Move-Out SF 2. My row dax works fine but the total is not working. Change SF is a measure of (Sum of All Area - Start SF) and I want to split that between two new measures (Move-In and Move-Out).

Any help is appreciated.

Thanks.

Re: Issue with Measure Total with an IF Statement

tamerj1 — Tue, 13 Dec 2022 03:23:26 GMT

Hi Brad_Roberts

Please use

Move-Out SF2 =
SUMX (
VALUES ( 'Tenency Data'[Tcode] ),
VAR ChangeSF = [Change SF] RETURN IF ( ChangeSF < 0, ChangeSF )
)

Re: Issue with Measure Total with an IF Statement

Brad_Roberts — Tue, 13 Dec 2022 14:42:34 GMT

tamerj1

That worked for one of the Tcodes but not the others:

Re: Issue with Measure Total with an IF Statement

tamerj1 — Tue, 13 Dec 2022 15:01:11 GMT

Brad_Roberts

What is the name of this column? Is ot from the same table?

Re: Issue with Measure Total with an IF Statement

Brad_Roberts — Tue, 13 Dec 2022 19:44:20 GMT

Property Code, same table for both snips.

Re: Issue with Measure Total with an IF Statement

tamerj1 — Tue, 13 Dec 2022 20:01:10 GMT

Brad_Roberts

Please try

Move-Out SF2 =
SUMX (
SUMMARIZE (
'Tenency Data',
'Tenency Data'[Property Code],
'Tenency Data'[Tcode]
),
VAR ChangeSF = [Change SF] RETURN IF ( ChangeSF < 0, ChangeSF )
)

Re: Issue with Measure Total with an IF Statement

Brad_Roberts — Tue, 13 Dec 2022 20:37:33 GMT

Same result as before: