Forum Discussion
Sort 100% Stacked Column Chart by Percentage Values
Okay I got the %s you say in the Post above - and they calculate exactly as you say!
However we were there before with the calculated columns only - those were producing the same results?
And you said they were wrong?
Sean once again, thank you so much for dedicating so much time to this. I've been very busy today and haven't been able to get back to it yet.
But, in a quick glance at what you've done, it looks like something is off.
For each Developer, Story Durations + Non-Story Durations = Total Durations [for that Developer, not for everyone]
The formulas you have look like they're calculating the Story % on a basis of all Developers.
Thus in the example above...
Ben should have Story % of 480 / 480 = 100% and Non-Story % of 0%
Tim should have Story % of 120 / (120 + 210) = 36.4% and a Non-Story % of 63.6%
Make sense?
Okay I got the %s you say in the Post above - and they calculate exactly as you say!
However we were there before with the calculated columns only - those were producing the same results?
And you said they were wrong?
This got it - thanks again Sean!
It still seems overly complicated to do something that I'd imagine many people would want to do. But, it also shows how much I need to learn basic DAX and how Measures work.
Thank you very much for sharing, I reviewed all the forum conversation and it worked perfectly, the example is of 2 categories, Story and Non-Story in my case I had 4 categories (Pass, Fail, Blocked and Non-Execute), but I followed the example and it worked! 👏