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 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?

 

 

 

 

1 Reply

  • 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