3 Replies Latest reply: May 23, 2016 4:55 AM by Jonathan Dienst RSS

    How to make this data connection?

    Evgeny Stuchalkin

      Hello! I have three tables:

       

      Deals: all deals connected to it's company

      Deal IDCompany
      11
      21
      32
      42

       

      Companyes:

       

      Company ID
      1
      2

       

      Notes: each company have some notes

       

      Note IDCompany ID
      11
      21
      32
      42

       

      In m app i have a measure: count([DISTINCT] [Note ID]), that shows me amount of notes, that related to company.

       

      What i want: I want see amount of notes, that related to company, when i'm selecting a Deal, related to company.

       

      First solution in my mind, make notes table like this:

       

      Note IDCompany IDDeal ID
      111
      112
      211
      212
      323
      324
      423
      424

       

      How i can make it?

      It also seem a little bit complicated.

       

      Is there any way to reach it with measure formula with set analysis?