Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBI % difference measure

Hi,    I would like to ask what is the equivalent of getting a % difference of two numbers in PowerBI measure?    I am used to this on excel and would like to replicate it in PowerBI please.   ...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 % 

 

 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

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.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I have the result now. Thank you for your help