DAX Look Up Value

[derekmac]

Hi All

I have picked up another persons report and come across the below Code, would someone be able to give me a brief indication of what this code is doing? Not seen the LOOKUPVALUE function used before 😞

Resourced EDV by Association = 
IF (
    'placements'[Role] = "Resourcer",
    IF (
        LOOKUPVALUE (
            'placements'[UserID],
            'placements'[PlacementID], 'placements'[PlacementID],
            'placements'[Role], "Deliverer"
        ) = 'placements'[UserID],
        0,
        LOOKUPVALUE (
            'placements'[EDV split],
            'placements'[PlacementID], 'placements'[PlacementID],
            'placements'[Role], "Deliverer"
        )
    )
)

[derekmac]

Apologies, didn't say that this was a Calculated Column

Wanted to understand what it is doing

[tamerj1]

@derekmac 
LOOKUPVALUE – DAX Guide

Introducing LOOKUPVALUE - YouTube

LOOKUPVALUE - DAX Guide - YouTube

Understanding LOOKUPVALUE - YouTube

Lookup multiple values in DAX - YouTube

[tamerj1]

Hi @derekmac 
Please try

Resourced EDV by Association =
VAR CurrentUserID = 'placements'[UserID]
VAR CurrentRole = 'placements'[Role]
VAR CurrentPlacementTable =
    CALCULATETABLE (
        'placements',
        ALLEXCEPT ( 'placements', 'placements'[PlacementID] )
    )
VAR DelivererTable =
    FILTER ( CurrentPlacementTable, 'placements'[Role] = "Deliverer" )
VAR UserID =
    MAXX ( DelivererTable, 'placements'[UserID] )
VAR EDVSplit =
    MAXX ( DelivererTable, 'placements'[EDV split] )
RETURN
    IF (
        'placements'[Role] = "Resourcer",
        IF (
            COUNTROWS ( DelivererTable ) > 1,
            "MultiDeliverer",
            IF ( UserID = CurrentUserID, 0, EDVSplit )
        )
    )