Text box to show conditional text based on selected dimesion

[#1]

Hi All,

I need an expression to put in a text box or create a variable using that expression to display text based on selected dimension

Data Model

• I have a Department Table
• And a Team Table (Which links to department with DepartmentId as foreign key)
• NOTE: Some Departments does not have teams

An an Example:

• Sales Department has 3 Teams (Team1, Team2, Team3 )
• And Finance Department has NO Teams

• If Department is selected as 'Sales'
• Then it should say 'Click here to drill down to team'

• If Department is selected as 'Finance'
• Then it should say 'No Teams for this department'
• Because this department does not have any teams
  

[marcus_sommer]

Maybe something like this:

if(count(distinct Department) >= 0, 'Click here to drill down to team', 'No Teams for this department')

- Marcus

[maxgro · Accepted solution]

try the attachment

= IF(GetPossibleCount(Team)>0 and GetSelectedCount(Department)=1, 'Click here to drill down to team', 'No Teams for this department / Select 1 department')