Calculate fixed total using two if statements

Question

I would like to calculate a fixed total on the following If [Term] = Fall 2021 and If [Affiliation] = "y" THEN Count [ID]

Jim Dehner - Tableau Visionary HoF · Accepted Answer

you were so close   this should work also  If   attr([Term] )= "Fall 2021" and attr( [Affiliation])  = "y" THEN Count [ID] End   Jim

DIEGO FERNANDO MARTINEZ RODRIGUEZ · Answer

@Mary Poe​  Hi, you can use something like: COUNT(IF [Term]="Fall 2021" AND [Affiliation]="y" THEN [ID] END) maybe is a distinct count: COUNTD(IF [Term]="Fall 2021" AND [Affiliation]="y" THEN [ID] END) If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.   Regards,   Diego Tableau Ambassador

Calculate fixed total using two if statements

Tableau Desktop & Web Authoring

Related Learning

More Help