Forum Discussion
PowerBI % difference measure
Hi,
Assuming Total and Outbound call are both measures in PBI Desktop, try this measure
Diff (%) = divide(([Outbound calls]-[Total]),[total])
Format this measure as %.
Hope this helps.
Hi, Anonymous
I think it is the same.
Or, you please try the below.
percentage difference = divide ( new value - old value, old value, blank() )
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
Thank you, I have tried your suggestion and its just not bringing the correct %
Below is what I have in excel and I need the exact result in PowerBI, I have tried calculate and divide function. It brings result everytime but not the correct %
Hi, Anonymous
please kindly try the below.
percentage =DIVIDE( SUM(Tablename[Outbound Calls]) - SUM(Tablename[Total]),SUM(Tablename[Total]), BLANK())if still does not work, please kindly share the sample pbix file, then I can try to look into it to come up with a desirable solution.Thank you.Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
Hi Jihwan_Kim
Please see attahced a sample file. I tried and its just not giving me the correct %
I have added the % I require by calculating in excel in my sample file. Thank you so much
https://drive.google.com/file/d/18hjL14yjIEd32T0hNh0dDWFz622TrrIj/view?usp=sharing
Hi, Anonymous
The link requires an access key.
Please check and let me know the public shared version.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
Hi,
Assuming Total and Outbound call are both measures in PBI Desktop, try this measure
Diff (%) = divide(([Outbound calls]-[Total]),[total])
Format this measure as %.
Hope this helps.
This works! Thank you so much!
You are welcome.