11 Replies Latest reply: Jun 8, 2017 12:14 PM by Sunny Talwar RSS

    Comparing two states row by row

    Tauseef Rehman

      Hi guys,

       

      I am trying to create a KPI which tells me the number of customers that purchased in one selection also purchased in the other. 

       

      Not sure how to do this, anyone know?

       

      This is my code in app:

      SUM(If([Transaction Member ID]={Alt}[Transaction Member ID],1,0))

       

      I may be doing this very wrong, any help is appreciated.

       

      Thanks in advance.