When an ID # with no reference it shows up "(Blank)"

[Boveitj]

Hey Guys,

I have asked this question already but havent gotten any answers that suit the needs of my project. The data I am aggregating is user input so there are several errors time to time. The bigggest error is when a person inputs their badge number wrong so it does not have an appropriate lookup in the relation table to display their name on the charts. Instead of showing up as "(Blank)" on all subsequent charts, is there a way I can make all badge numbers that dont have a lookup show up as "Invalid ID Entered".  The way I construct the charts is by having table 1 and table 2 have a 1 to many relationship so it cooreleates a name with the BadgeID. By placing "Name" and "Number of sales" in the "Axis" portion it creates a chart with each persons name and the number of sales they had. The problem I am having is a column that is "(Blank)" for all the sales that had an invalid ID placed under them. I would like this to show up as "Invalid ID Entered" 

Example: 

Table 1:                               Table 2:

Badge IDs                       Badge IDs         Name

   456                                  321                   Joe

   321                                  456                   Melissa

   765                                  765                   Steve

456 would show up as Melissa, 765 would show up as steve, 321 would show up as joe, but 123 would show up as "Invalid ID entered" and not "(Blank)"

Thanks in Advance!

[Boveitj]

Hey Guys,

I have asked this question already but havent gotten any answers that suit the needs of my project. The data I am aggregating is user input so there are several errors time to time. The bigggest error is when a person inputs their badge number wrong so it does not have an appropriate lookup in the relation table to display their name on the charts. Instead of showing up as "(Blank)" on all subsequent charts, is there a way I can make all badge numbers that dont have a lookup show up as "Invalid ID Entered".  The way I construct the charts is by having table 1 and table 2 have a 1 to many relationship so it cooreleates a name with the BadgeID. By placing "Name" and "Number of sales" in the "Axis" portion it creates a chart with each persons name and the number of sales they had. The problem I am having is a column that is "(Blank)" for all the sales that had an invalid ID placed under them. I would like this to show up as "Invalid ID Entered" 

Example: 

Table 1:                               Table 2:

Badge IDs                       Badge IDs         Name

   456                                  321                   Joe

   321                                  456                   Melissa

   765                                  765                   Steve

456 would show up as Melissa, 765 would show up as steve, 321 would show up as joe, but 123 would show up as "Invalid ID entered" and not "(Blank)"

Thanks in Advance!

[fhill · Accepted solution]

I didn't see your other post, so i'm not sure if this has been suggested yet?  Hope it helps, FOrrest

Created on the "ID Master" table...

Name = IF(ISBLANK(RELATED(Table2[Name])),"Invalid ID Entered",RELATED(Table2[Name]))