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 ))

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

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