Chelsie Eiden's Duration

Chelsie Eiden is my new favorite human being on the face of the planet. I don't know her major but, even if she is majoring in math, it still wouldn't change my mind on this one. That's how much I li...

ChelsieEidensDuration.pbix145 KB

Other

Time Intelligence

Totals

bgriff135

Frequent Visitor

4 years ago

Greg_Deckler This is great, super helpful, thank you for sharing. I've found one issue though - if you use a legend in the colomn chart, the total values are not accurate. The Total becomes a sum of each part of the time calc and you can get minutes and seconds greater than 60 (ex from the provided file, the total becomes "114:77:61" instead of "115:18:01") . Is there a way to structure this meausre so it displays correctly when a legend is added to the visualization? Screenshot below and pbix file attached. Thanks!

ChelsieEidensDuration with Legend.pbix141 KB

Greg_Deckler
Community Champion
4 years ago
bgriff135 I am going to guess that what is going on is that you essentially have kind of a measures totals problem going on but may have to take a closer look. So, I'm wondering if you need to do this essentially: Quick Measure, Measure Totals, The Final Word:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907