Forum Discussion

privledged_test's avatar
privledged_test
New Member
1 year ago
Solved

Use Measure to create Calculated Column

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 i...
  • pankajnamekar25's avatar
    1 year ago

    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.