6 Replies Latest reply: Aug 23, 2016 4:46 AM by Joanna Seldon RSS

    count expression and limit to 1

    Joanna Seldon

      Hi

       

      is there a way of count expression on a table chart on a sheet, and then limit that count to 1?

       

      I have a table on a sheet, and my expression on the measure is.. count ( distinct Country = {Denmark} >} sales)...this gives 0 and 1

       

      can this count then be limited to just 1 please and exclude the 0

       

      please help