Forum Discussion
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...
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 | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
This works great, thanks a lot!