1 Reply Latest reply: Aug 20, 2018 1:20 AM by Mahitha M RSS

    Calculation Help

    Mahitha M

      Hi Experts,

       

      stalwar1

      youssefbelloum

      omarbensalem

      jyothish8807

       

      Could you please help me on below requirement.

      In the below Table I have Taken

       

      Dimension as [Internal ID]

      Measure as

      if(

      ISNULL(AGGR(

      if(Match([Sales Product],'TV'),[Performance External ID],

      if(Match([Sales Product],'Mobiles'),[Performance ID])),

      [Internal ID])),count([Internal ID])


      1. When I have used above dimension and measure in first table with Total as Auto and By checking Data Handling getting total measure count  as 4807.


      2. In the second table I have changed Total as Sum and uncheck the Data handling so all null ids were removed and getting total measure count as 2966.


      The requirement is I have to show 2966 count in KPI. How to change the above expression for getting 2966 count with above table settings.

      Please help me on this.