Divide function not showing correct result

[Hijau]

Hi community,

I'm trying to use the divide function but it's not showing the correct results for me. The formula looks like this: 

Omloopsnelheid = DIVIDE(SUM(GRV_StockpositionsPerDay[Stock]);SUM('100_Voorraadmutaties'[Eruit positief]);0)

The GRV_StockPositionsPerDay[Stock] is the 'Voorraadstand' in the first picture. The 100_Voorraadmutaties[Eruit positief] is the Eruit posititief in the second picture. So what I want is 65.401,00 / 700.348,00 = 0,09338... But it's giving me 0,00290.

Anyone who knows how to tackle this problem? Thanks in advance!

Kind regards,

Dexter

[gipiluso · Accepted solution]

it seems that the two table is not properly related.

Look to whats append if you bring the "Eruit positief" column in the first table.

If you don't solve post the pbix, i'll try to take a look.

GP

[Hijau]

Thank you GP, when you said relation I checked into the relation between the tables and thats fixed it! 🙂

[quentin_vigne]

Hi @Hijau

If you don't use SUM function, does it display the correct value ? 

 - Quentin 

[Hijau]

If I just divide the columns without using DAX it gives the same answer. Also when I use divide the numerator and denumerator need a function I believe.