BUG? Looks like referencing a referenced row shows up as blank or as the referenced number.

[booyah]

I tried to reference this article.  However, It doesn't give a clear definition of how this was solved. I have the same issue. 

these are two different tables. the top table is "comp_org_table" and the bottom is "competition_table" 

the competition_table.name refers to comp_org_table. the label for this reference is comp_org_table.org_name. This works fine in all other aspects save the calendar. where it only shows either blank, or the ID of the record. I've tried all sorts of dereferencing and read a bunch of articles. Just am having a tough time wrapping my head around why this isn't working. 

thanks in advance. 

[WillowMobileSys]

I think you mis-understand how a Ref column works.

When you define a column as REF, it MUST be assigned the row key from the referenced table.  Think of it as a "pointer" to the entire row.

Each table provides a feature to set a column as the "Label" column.  This is simply so you can have a user friendly value shown that represents that row instead of the row key which is usually a random identifier or some number.  AppSheet will use this "Label" column value, in the app displays only, automatically replacing the row key for you.  Uses in actions and expressions will operate on the physically stored value in the Ref column which is the row key.  I.E. ... You cannot link to the row using this "Label" column.

So...in your use case you have the expression FILTER("comp_org_table", [ORG_NAME] = [_THISROW].[NAME]). This won't find a matching row because the [NAME] column is expected to have the value from the ID column of the "comp_org_table" table.

Instead, this expression should be:

FILTER("comp_org_table", [ID] = [_THISROW].[NAME])

 Many App Creators will name their Ref columns the name of the row key column - so "ID" or "ORG_ID" in your case - as a reminder to help avoid confusion.

I hope this helps!