Forum Discussion

diogovaz's avatar
diogovaz
Frequent Visitor
8 years ago
Solved

Calculated Fields

Hello,

 

I have these 3 tables:

 

 

 

 

 

 

 

 

 

 

 

I want to create a calculate field with the sum all Net Sales by Client on table CRM Client. How can I do it? Any ideas?

 

Thanks,

 

Need Help
Tips and Tricks
  • diogovaz's avatar
    diogovaz
    8 years ago

    Hi,

     

    The proper answer is this one: Measure = SUMX('CRM Client';'PCS Sales'[NET Value CHF Measure])

5 Replies

  • bsas's avatar
    bsas
    Post Patron
    8 years ago

    Hi diogovaz,

     

    You can create measure like test = SUMX(CRM Client, Sales[Net Sales CHF]>0). Or use calculate.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Drag CRM Client ID from the CRM_client table (Table 3) and then write the following calculated field formula in the Sales table

     

    =SUM(Sales[Net Sales CHF])

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi diogovaz,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale

    • diogovaz's avatar
      diogovaz
      Frequent Visitor
      8 years ago

      Hi,

       

      The proper answer is this one: Measure = SUMX('CRM Client';'PCS Sales'[NET Value CHF Measure])