How can I count only specific values in tabluea?

Question

I have a medal column, there are 4 different values in the medal column gold, silver,bronze, and NA, I don't want to count the NA column in the calculated field in tableau

I want to do something like this

Count(Medals(not including NA))/count(Medals)

Answer 1

if you want to exclude NA, Try to use this:

IF ISNULL([medal: NA]) THEN [medal] END

nb. if table name is medal, and expression are gold, silver,bronze, and NA

then you can use count

Answer 2

One solution is

SUM(INT([Medal] <> “NA”)) / COUNT(“*”)