Measure calculate bad totals

[kintela]

Hi

I'm trying to show a report with the certifications of the projects in my ERP SAP Business One where I have 2 companies

I have this relationships

That is, head and details of the invoices of the FULCRUM companie and SERS Companie.

Then I have created the measures

CertificadoFULCRUM = SUMX(DetalleCertificacionesFULCRUM;DetalleCertificacionesFULCRUM[ImporteSinIVA])

CertificadoSERS = SUMX(DetalleCertificacionesSERS;DetalleCertificacionesSERS[ImporteSinIVA])

CertificadoTotal = [CertificadoFULCRUM]+[CertificadoSERS]

So I create my Report and I add the fields Proyecto.ID, Proyecto.Name and CertificadoTotal measure

But in the first Project I see an error

If I compare this value with the sum of invoices real in the origin SQL

IN FULCRUM companie

That sumes 463.879,68€

In SERS comopanie

That sumes 0

In fact If I create this report

I get the correct value

So the measure what is calculating???

Regards

[Vvelarde]

@kintela

Hi, have a question : why are using SumX? Maybe you can try with Sum and Calculate.

[kintela]

@Vvelarde

Hi,

I have changed SUMX by SUM with the same result

regards

[Vvelarde]

@kintela

Please add the measure separates in your first report to see what measure is failing or both.

[kintela]

@Vvelarde

If I use a calculate column the value is correct

But I don`t know why the measure calculates that value

Regards

[kintela]

@Vvelarde

CertificadoFULCRUM = SUM(DetalleCertificacionesFULCRUM[ImporteSinIVA])

CertificadoSERS = SUM(DetalleCertificacionesSERS[ImporteSinIVA])

CertificadoTotal = [CertificadoFULCRUM]+[CertificadoSERS]

If I calculate in T-SQL

¿¿¿???