Solved: Re: percentage difference

Anonymous · ‎08-31-2020

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

lkalawski · ‎08-31-2020

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! 😀

View solution in original post

v-xuding-msft · ‎08-31-2020

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

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lkalawski · ‎08-31-2020

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! 😀