Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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?
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??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |