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

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