Sum of Measures and Totals

[Syndicate_Admin]

Good afternoon, first of all thank you for your time. I have made a table of sale by customers (Table lineasalbarancliente). The "%" field (Column2) is a numeric data that comes from the customer table (Customers Table). The field "Base result by %" is a measure that comes out of multiplying the two fields that come from different tables:

Base result per % = Calculate(sum(lineasalbarancliente[basetax]) * sum(clients[%])

The error is that the % is adding it to you and therefore the result of column 3 (Tax base by %) is multiplying the result of column 1 by 1388.00%, instead of adding all the rows of column 3.

Surely the result is something simple but it has me lost.

Thanks in advanceª

[Syndicate_Admin · Accepted solution]

SOLVED:

I have created a new measure which is:

SUMX(lineasalbarancliente,lineasalbarancliente[medida_anterior])

doubt resolved THANK YOU!!