Forum Discussion

third_hicana's avatar
third_hicana
Icon for Helper IV rankHelper IV
2 years ago
Solved

Calculate Distinct Values in a Column then Filter by another column with blanks

Hi. Seeking your help regarding how to calculate my date. I want to calculate the unique departments that have no value in FTE. Below is my sample data.  My desired result is 2 because there are two...
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    third_hicana 
    countrows(calculatetable(values(Table[Department]), Table[Est FTE] > 0 ))

third_hicana's avatar
third_hicana
Icon for Helper IV rankHelper IV
2 years ago

Hi tharunkumarRTK 

How can I calculate the number of departments with no FTE value but also check that no projects have no FTE value?

So my desired  result is 1 because Department 3 has no value in Project A and Project B.

There's no only 1 department that has no FTE value for all of the projects. Basically, I want to check how many departments that has no FTE value across all projects.

Thank you.