Forum Discussion
Display remaining percentage
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.⚡
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.
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])
Yes, I am trying to replace Budget Used with Budget Remaining. Below is the results after adding in the measure you provided (Test Budget Used column). I don't understand why it's not working. I also need to figure out a solution that will not cause the table to include all of the tasks with empty data.
Before:
After:
KBVelasco add this as a measure not column and change it to something like this and then check
% Remaining = ( 1 - [Your Measure] ) * DIVIDE ( [Your Measure], [Your Measure] )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.⚡
Worked
