1 Reply Latest reply on Jun 21, 2018 3:10 AM by Zhouyi Zhang

    Table Suppress/Hide Zero

    Alexsander Hopeless
    Alexsander Hopeless Jun 21, 2018 1:11 AM

      Hi Guys , I would like to hide all zero row

       

       

      I have 3 calculated measures which depend on A value ( The measure value has to do in this way)

      e.g.

      Count 1 - if A=1 then 1 end

      Count 2 - if A=3 then 1 end

      Count 3 - if A=4 then 1 end

       

       

      then i place it in Measure Value

       

       

      But what i want is - Expected Result - Hide all Zero row

       

       

      My Attempt - Filter all 0 row by place CNT(count 1) to filter it hides others measure value as well

       

       

      pls help thx