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

    count expression and limit to 1

    Joanna Seldon



      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