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?   ...
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])

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])