I have an action set up (on table Districts) to go to another view within the app (table Assigned Coaches), which is set to Display Prominently. I would like the button to only appear if there are actually any assigned coaches to the district. I have a ref column set up (Short Name) that is the same on both tables.
I believe the solution lies in an “Only if this condition is true” expression, but I just don’t have the fluency to figure it out. I’ve tried several things with INDEX(), IN(), and CONTAINS() and have read all the help files on these. The closest I came to is:
CONTAINS(Coach Assignments[Short Name],[Short Name]=[_THISROW].[Short Name])
But this doesn’t return a True/False value.
Any assistance would be most appreciated.