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ª