Forum Discussion
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 that should not be included in the report. It's worth noting the measure below works exactly how I want it to.
7 Replies
- parry2k
Super User
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.
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:
- parry2k
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
