
1. Re: Using the excel equivalent of COUNTIFS in Tableau
Joe Oppelt Nov 6, 2017 12:57 PM (in response to Eric Kolman)1 of 1 people found this helpfulA multitiered ifelseif calc will stop when the first condition is met.
That's because a calc can have only one value per row.
Are you trying to determine that out of the 10 users, 8 chose value 1, and 4 chose value 2, and ... etc? (So the sum of these counts can add up to more than the number of users because a user can select more than one value?)

2. Re: Using the excel equivalent of COUNTIFS in Tableau
Eric Kolman Nov 6, 2017 1:02 PM (in response to Joe Oppelt)Hi Joe,
Thanks for the quick reply. That now makes total sense why the values are not right.
Yes that is essentially what I am trying to do. We would also like bring in a few different metrics (avg age, avg tenure, avg salary) to show how they differ by org type.

3. Re: Using the excel equivalent of COUNTIFS in Tableau
Jim Dehner Nov 6, 2017 1:13 PM (in response to Eric Kolman)1 of 1 people found this helpfulHi Eric
I would really like to see your workbook on this  in a twbx format with the data to see the data and how your formula is working
it seems pretty complex but maybe that is needed
With tableau if functions the calculation will process and If clause until it finds a true then it will apply the Then clause and move on to the next record
If you data is structured like you show with a single record containing multiple values for org type tableau will not see them all 
You reference an excel function  there is a fundamental difference between excel and tableau  excel is a cell based system where the calculation is done at the cell level and moves cell to cell
Tableau is data base drive and calculations are applied to measures along dimensions  Think like and entire column in excel 
So what  Tableau wants to see all your "Org type" data in a single column and your user information in another single column and yes that would result in 2 records for User 2 and 3 Records for user 5  then you can use something like {fixed [org type] : countd(user)} to do your count 
The fixed statement in words would read for each org type count the distinct number of users  (it will count user 2 and 5 in each of their org types0
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

4. Re: Using the excel equivalent of COUNTIFS in Tableau
Jim Dehner Nov 6, 2017 1:15 PM (in response to Joe Oppelt)sorry Joe
Didn't see you were already helping eric out
Jim

5. Re: Using the excel equivalent of COUNTIFS in Tableau
Joe Oppelt Nov 6, 2017 2:15 PM (in response to Jim Dehner)Jim Dehner wrote:
Hi Eric
...
Tableau is data base drive and calculations are applied to measures along dimensions  Think like and entire column in excel 
So what  Tableau wants to see all your "Org type" data in a single column and your user information in another single column and yes that would result in 2 records for User 2 and 3 Records for user 5  then you can use something like {fixed [org type] : countd(user)} to do your count 
...
Eric  This is what my question was leading to. ^^
If you cannot reshape your data like this, then you can create in Tableau as many calcs as there are possible choices from the multi select list. You can do it that way, but if there are 100 possible choices, it can get pretty cumbersome.