Return a value from column when true or false in if statement(calculated measure)

Question

Hi Experts,&nbsp;I know If statment return only scalar value. But can we get the value from column in dataset when true or false in if statement.&nbsp;I want to achieve this only by calculated measure and not a calculated column&nbsp;&nbsp;I have a table below:RegionManagerIDOld Dep nameNew&nbsp; Dep NameNorthRam0RRRGGGEastsat0RRRGGGwestmag1RomRomsouthMit2CasCassouthMit3GonGonNorthRam4HenHen&nbsp;Calculated measure =&nbsp;if(sum(id)&gt;0,old dept name,new dept name)&nbsp;Expected output in table:&nbsp;RegionMangerDep Name(using if measure)NorthRamRRREastSatRRRWestmagRomSouthMitCas

sachinnandanwar · Accepted Answer

Something like this&nbsp;If(Calculate(SUM(Table[ID]),ALLEXCEPT(Table,Table[Region])&gt;0,MAX(Table[olddepname]),MAX(Table[newddepname]))&nbsp;

Forum Discussion

Return a value from column when true or false in if statement(calculated measure)

1 Reply

Related content

If Statement Calculated Column Returning Incorrectly

Measure returning incorrect value

If statement in calculate Measure

Calculating Measures Totals after if statement

DAX Calculate IF OR Statement

Region	Manager	ID	Old Dep name	New Dep Name
North	Ram	0	RRR	GGG
East	sat	0	RRR	GGG
west	mag	1	Rom	Rom
south	Mit	2	Cas	Cas
south	Mit	3	Gon	Gon
North	Ram	4	Hen	Hen

Region	Manger	Dep Name(using if measure)
North	Ram	RRR
East	Sat	RRR
West	mag	Rom
South	Mit	Cas