Total not correct

[skivlugt]

My total is not correct and I dont understand why:

The total of "project 2022" and "budget vorig jaar" is correct but "benodigd VJ" is not.
The total of "benodigd VJ" should be around 1883,46.
I used the following measures:

benodigd VJ = [budget vorig jaar]-[project 2022]

benodigd VJ (0) = If ([benodigd VJ] < 0,0,[benodigd VJ])

"project 2022" is my worked hours per customer
"budget vorig jaar" is my budget
"benodigd VJ" should be my remaining hours left to work, with 1 condition: if my worked hours is more then my budget it should say 0.

[Anonymous]

Hi @Uzi2019 ,thanks for the quick reply.

Hi @skivlugt ,

Regarding your question, the 'Total' row has no filter. You are correct in mentioning the totals for "project 2022" and "budget vorig jaar". This indicates that the two data are the sum of the dataset (no filters are applied).I think 959.09 is the correct answer, if I'm wrong, can you share some data?

[Uzi2019]

Hi @skivlugt 
Instead of sharing screenshot can you share the direct data just copy and paste it here.

Or share pbix file of your data so will look into this??