Use Measure to create Calculated Column

[privledged_test]

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)

[privledged_test]

This works great, thanks a lot!

[pankajnamekar25 · Accepted solution]

Hello @privledged_test 

try this DAX for column

MiscLineColumn =

VAR CurrentOrder = '2025'[Order]

VAR CurrentLine = '2025'[Line#]

VAR FirstLine =

    CALCULATE(

        MIN('2025'[Line#]),

        FILTER(

            '2025',

            '2025'[Order] = CurrentOrder

        )

    )

VAR MiscValue =

    CALCULATE(

        MAX('2025'[value.OrderHed_DocTotalMisc]),

        FILTER(

            '2025',

            '2025'[Order] = CurrentOrder

        )

    )

RETURN

    IF(CurrentLine = FirstLine, MiscValue, 0)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.