9 Replies Latest reply: Jun 5, 2018 11:22 AM by Глеб Аитов RSS

    Count Dimension only if Measure is positive

    Глеб Аитов

      Trying to make simple calculation, tried both of below formulas, neither worked (still counts brands with Qty=0), please, help:


      1. if(sum( [SalesQty]) > 0, count( distinct [Brand]),0)


      2. count(

      aggr(sum( {<SalesQty={">0"}>} Qty, Brand)

      )