Forum Discussion
Solved
Handling blanks
How do I return "Unassigned" in my table visual when the User doesn't exist? See example below. Ultimately I want to do some counts of projects by user and show how many are unassigned in a table. I...
Hi nchamilton2 ,
Please create the following measure:
Project Name =
VAR AssignedName =
LOOKUPVALUE(
Table1[Name],
Table1[UserId],
SELECTEDVALUE(Table2[UserId])
)
RETURN
IF(
ISBLANK(AssignedName),
"Unassigned",
AssignedName
)Add the Project Name measure and ProjectId from Table2 to your table visual.
This measure will return the actual name if it exists or "Unassigned" if there’s no match.
Expected Output
Name ProjectIdJim 123 Bob 456 Mike 789 Unassigned 987 Hi nchamilton2 create a calculated column in table 2
DisplayName =VAR User= LOOKUPVALUE(table1[Name], table1[UserID], table2[userid])RETURN IF(ISBLANK(User), "Unassigned", User)
Hi nchamilton2
Could you please confirm if your query have been resolved the solution provided by MattiaFratello and techies ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you