Forum Discussion

KBVelasco's avatar
KBVelasco
Frequent Visitor
6 years ago
Solved

Display remaining percentage

What is the easiest way to display the remaining percentage of the following measure (ie. show 8% instead of 92%)?  Everything I've tried either returns the wrong value or applies a value to rows tha...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    KBVelasco and make sure format is changed to % 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

KBVelasco not sure if I understood it correctly, add another measure for remaining %

 

% Remaining  = 1 - [Budget Used]

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

KBVelasco and make sure format is changed to % 

  • KBVelasco's avatar
    KBVelasco
    Frequent Visitor
    6 years ago

    That was one of the steps I was missing!  Your first recommendation worked once I changed the formatting.  Now I just need to filter out the "100%" on the rows without any data.

  • KBVelasco's avatar
    KBVelasco
    Frequent Visitor
    6 years ago

    This is what I ended up with.  Everything looks like it's working as it should.  Thank you!

     

    Budget Remaining = IF([User Budget]>0, 1 - [Budget Used %], [Blank])