• Hi, yeah CountDistinct will do that, if every value in the column is the same, which it looks like it is (year?).

    One solution would be to change the column in your expression to one that's unique in every row, and that you can guarantee it always will (else future counts could be wrong), or go back to using just Count - still not sure what was wrong with that first time around 🙂

    Cherrs