7 Replies Latest reply: Mar 22, 2017 10:17 PM by Anil Babu RSS

    Help! - distinct keyword not working like i thought

    Maria Harmening

      I have a measure calculation..

      Count(distinct {$

      <BINFlagToday={1}>}

      BIN)

       

      my data looks like this

       

      BIN    BINFlagToday      Emp       EmpFlagToday

      123     1                           John       1

      123     1                            Tom        1

      123     1                           Jerry        1

       

      this means that I have 3 employees in one position today at this moment.  I thought that the above measure would return 1, but it's returning 3 (I think).  how can I return only 1?