Forum Discussion

derekmac's avatar
derekmac
Icon for Helper I rankHelper I
3 years ago

DAX Look Up Value

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 use...
DAX
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

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 )
        )
    )