10 Replies Latest reply: Jan 30, 2017 8:01 AM by Guillermo Rio RSS

    sum values with condition measure based on a dimension

    Jithu J
      Product_TypeSalesExpected result : Product Type without sales
      Type18990
      Type23450
      Type301
      Type45670
      Type52350
      Type64560
      Type701
      Type8460
      Type901

      I have a table like above one (agg all the rows based on sales) I am trying to create a measure like Product Type without sales

      Used the expression =Count({$<Sales={"0"}>} distinct [Product_Type])

      But it is not working ... I am getting '1' in all rows for the measure "Product Type without sales"

       

      Just FYI, the actual table will have rows at day level . I have just showed you the aggregated table. So here sales is sum(sales) so that if I pull the product_type dimension it do a group by

       

      can anybody help me to solve this??

       

      Thanks