Forum Discussion
No Total Showing
Hi,
I'm a new Power BI user and am slowly piecing things together but it's not going well. I have a weird setup and looking for some guidance.
I have data from Jira tickets where "components" is coming in as text (ten, twenty, etc). I created an excel sheet and have a column for the text (components) and then a column for the numbers (NumberTime) (row 1: ten, 10; row 2: twenty, 20, etc). In Power BI I mapped the two data sources together.
When I pull the data into the report view the NumberTime doesn't have a total on the table:
I'm trying to figure out how to show the sum'ed time. I couldn't figure it out so after reading these forums I tried creating a TotalTime measure but am not sure how to do that. I don't know if this is the best process but if someone can let me know how to set this up to calculate it would be greatly appreciated. Or if there's a better way to do this I'm open 😅 Thanks in advance!
Note: I tried to add
TotalTime =COUNT('mots_gtm_jira'[label_value]) * MIN('Time'[NumberTime]) which puts the correct numbers in the column but then the total is showing as 30.
- Anonymous3 years ago
8 Replies
- DOLEARY85Resident Rockstar
Hi,
it looks like the NumberTime isn't in a numeric field type, try changing it to a whole number, it should automatically sum then
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- AnonymousNot applicable
DOLEARY85 NumberTime is a whole number already 🤔
- DOLEARY85Resident Rockstar
Ah okay, maybe it's because no summarisation is selected that it didn't look like a number from the Field Name - try changing the summarization to Sum
- AnonymousNot applicable
Still no luck