Forum Discussion

skivlugt's avatar
skivlugt
New Member
2 years ago

Total not correct

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.

Need Help

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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?