cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KBVelasco
Frequent Visitor

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.

 

Budget Used = DIVIDE(
    SUM('TimeEntries'[Hours Logged]),
    SUM('TaskAssignees'[Estimated Hours])
)
 
Thank you
1 ACCEPTED SOLUTION

@KBVelasco and make sure format is changed to % 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

6 REPLIES 6
parry2k
Super User
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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@KBVelasco and make sure format is changed to % 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

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])

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:

KBVelasco_0-1594674685023.png

 

After:

KBVelasco_1-1594674716907.png

 

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.