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.
Solved! Go to Solution.
This is what I ended up with. Everything looks like it's working as it should. Thank you!
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.
@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] )
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.