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

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.