Amount doesn't return propper in tabel just gives total amount

[KurtDP]

The tables are linked with "order nummer"
Relations are fine, 1 to 1 is correct between d_inkooporderinfo and f_inkooporderTotalen
I checked all datatypes (all properties of 'order nummer' are identical).

First there was a datatype difference but now all are text

Then there was still a difference in the modelview but corrected it to

Also already refreshed, relaunched ... the client

Measures that return total

Openstaand = CALCULATE(SUM(f_InkoopordersTotalen[Openstaand]))

Gereserveerd = CALCULATE(SUM(f_InkoopordersTotalen[Gereserveerd]))

Measure that works fine

Gefactureerd = CALCULATE(SUM(f_facturen[Totaal Gefactureerd EUR]))

So at first sight the problem should be in powerQ or properties datamodel

Programma is linked to f_facturen and not direct to the other two d_inkooporderinfo and d_inkooporderTotalen.

Edit 1 So now I added the same column to the table and still not working.

I have no idea what to try next.

Edit 2

When I use the column programma in the f_inkooporderTotalen it works just fine
But that is not the right way.

Edit3

 I realised one relationship was hidden but when I make it active it gives me an error

 Hope someone here can help me out but nevertheless making progress.

Last Edit

If anyone sees the solution, I would love to read it.

I solved my problem by getting the data differently into powerquery.