Forum Discussion

Edgar_massa's avatar
Edgar_massa
Icon for Helper II rankHelper II
3 years ago

Divergent sum

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 ...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Edgar_massa ,

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