Use Measure to create Calculated Column

Question

In the screenshot of dataset below I'm using following measure to assign values in line 1 to remove any duplicates. The measure calculates correctly but how do I bring measure value in the same row in dataset so I can see Line 1 as 800 and then all subsequent lines as 0

MiscLine =

VAR CurrentLine = SELECTEDVALUE('2025'''[Line#])

VAR FirstLine =

CALCULATE(

MIN('2025'''[Line#]),

ALLEXCEPT('2025''','2025'''[Order Total])

)

RETURN

IF(CurrentLine = FirstLine, MAX('2025'''[value.OrderHed_DocTotalMisc]),0)

pankajnamekar25 · Accepted Answer

Hello&nbsp;privledged_test&nbsp;&nbsp;try this DAX for columnMiscLineColumn =VAR CurrentOrder = '2025'[Order]VAR CurrentLine = '2025'[Line#]VAR FirstLine =&nbsp;&nbsp;&nbsp; CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MIN('2025'[Line#]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '2025',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '2025'[Order] = CurrentOrder&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; )VAR MiscValue =&nbsp;&nbsp;&nbsp; CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAX('2025'[value.OrderHed_DocTotalMisc]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '2025',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '2025'[Order] = CurrentOrder&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; )RETURN&nbsp;&nbsp;&nbsp; IF(CurrentLine = FirstLine, MiscValue, 0)Thanks,&nbsp;Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Forum Discussion

Use Measure to create Calculated Column

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

DAX Calculated Measure

DAX Measure for Ranking the valid rows and calculating the average rating

Need help to create Calculation in DAX