Divergent sum

Edgar_massa — Fri, 20 Jan 2023 20:06:07 GMT

Good afternoon sirs

I'm having problems adding a measure called "Edgar Billing", from a visual, where I disregard the column "CompanyId" and the column "vl_Tarifa_2".

In the print below, the first table is ok with the tariffs, (except the total), bringing the amounts to be invoiced from customers.

In the table below, it is showing a totally different value.

As the calculation is a column multiplied by a measure, I used a Calculate function and the MAX function to get the day's tariff.

What would you do?

Re: Divergent sum

Anonymous — Sat, 21 Jan 2023 04:45:03 GMT

I think you can try if you wnat the correct sum of the total:

If(hasonevalue(table[company_id]),[faturamento_Edgard],sumx(values(table[company_id]),[faturamento_Edgard]))

This will fix your total.

And i dont think all is necessary in your calculation, if you already have a relationship just a simple

Max(table[vl_tarifa_2]) would do the trick