Skip to main content
Topics#Tableau Desktop & Web AuthoringSurendra Sharma's Question
Surendra Sharma asked in #Tableau Desktop & Web Authoring
Jul 31, 2015, 10:06 AM

Help with distinct billable status

Hi all, I have a table which contains associate names and their billable status. Some associates are billable on two or more projects. I created a calc field to display billable associates. But some associates are billable on two or more projects. So I want to display only distinct count of billable associates. Can someone help?

 

Help with distinct billable status

Here you can see Billable is Showing 20 whereas it should be 19 because one associates is billable on 2 project. Here's the calculation I am using

IF ([Billable])="Yes" THEn [Billable] END

 

I tried using COUNTD() but it gives error.

bill_1.png

 

Thanks,

Suri

6 answers
  1. Rody Zakovich
    Jul 31, 2015, 12:14 PM

    Hello Suri,

     

    If that is a separate Dimension, than why not just reference it in the calc

     

    COUNTD(IF ([Billable])="Yes" THEN [Billable Associates] END)

     

    That will give you the COUNTD of Billable Associates when [Billable] = 'Yes'

     

    Does this help?

     

    Regards,

    Rody

Write an answer...
0/9000