Help With Table Visual - Measure

[apmulhearn]

Hello, 

I have a table which contains info about individual guests, and info about the trips they are taking.

I am seeking a measure to put the blue column below in a Table Visualization.
The blue text explains the logic I'd like it to use, but I can't get it correct.

[Anonymous · Accepted solution]

Hi @apmulhearn,

You can try to use the following measure formula to compare with current Trip and Completed to turn tag:

Status =
VAR currTrip =
    CALCULATE (
        MAX ( Table[GuestsonTrip] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[TripID] )
    )
VAR complete =
    CALCULATE (
        SUM ( Table[Completed] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[TripID] )
    )
RETURN
    IF (
        currTrip = complete,
        "All",
        IF ( complete > 0 && complete < currTrip, "Partial", "None" )
    )

Regards,

Xiaoxin Sheng