Calculated Fields

[diogovaz]

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,

[v-jiascu-msft]

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 · Accepted solution]

Hi,

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

[v-jiascu-msft]

Hi @diogovaz,

CALCULATE() may be needed.

Best Regards!

Dale

[Ashish_Mathur]

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

[bsas]

Hi @diogovaz,

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