Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |