Issue with Measure Total with an IF Statement

Question

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.

tamerj1 · Answer

Hi&nbsp;Brad_Roberts&nbsp;
Please use
Move-Out SF2 =SUMX (VALUES ( 'Tenency Data'[Tcode] ),VAR ChangeSF = [Change SF] RETURN IF ( ChangeSF &lt; 0, ChangeSF ))

brad_roberts · Answer

tamerj1&nbsp;&nbsp;That worked for one of the Tcodes but not the others:&nbsp;&nbsp;&nbsp;

tamerj1 · Answer

Brad_Roberts&nbsp;
What is the name of this column? Is ot from the same table?

&nbsp;

brad_roberts · Answer

Property Code, same table for both snips.

tamerj1 · Answer

Brad_Roberts&nbsp;
Please try
Move-Out SF2 =SUMX (SUMMARIZE ('Tenency Data','Tenency Data'[Property Code],'Tenency Data'[Tcode]),VAR ChangeSF = [Change SF] RETURN IF ( ChangeSF &lt; 0, ChangeSF ))

Forum Discussion

Issue with Measure Total with an IF Statement

6 Replies

Related content

Financial Statement - Measure issue

Build issues with CTAS statements in Stored procs

PowerBI measure IF statement

Measure IF statement for each row

If Statement in Measure