Forum Discussion
percentage difference
hiiii
i was caluculating sla% but my data is been calculated for 200% insted of 100%
i am attaching a pbix file link
https://drive.google.com/file/d/1aGOdgI-FCuB9b5VcVxs6jsp7OzeLbuMc/view?usp=sharing
Hi Anonymous
You add 100 + 100 so there is no other choice but to achieve 200%.
From what I can see you are doing the same query twice, so there must be a bug here. Delete the second part of the query and the return value will be 100% or less.
_______________
If I helped, please accept the solution and give kudos! 😀
2 Replies
Hi Anonymous ,
lkalawski is right. It is caused by addition.
I'm not clear about what you want. Can you please share the calculating logic with us?
What I try
Hi Anonymous
You add 100 + 100 so there is no other choice but to achieve 200%.
From what I can see you are doing the same query twice, so there must be a bug here. Delete the second part of the query and the return value will be 100% or less.
_______________
If I helped, please accept the solution and give kudos! 😀
