Issue with Measure Total with an IF Statement

[Brad_Roberts]

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.

[Brad_Roberts]

@tamerj1 

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

[tamerj1]

@Brad_Roberts 

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

 

[Brad_Roberts]

Property Code, same table for both snips.

[tamerj1]

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

[Brad_Roberts]

Same result as before:

[tamerj1]

Hi @Brad_Roberts 

Please use

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