Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    3 years ago

    DOLEARY85 i ended up creating a new column and it works:

     

    Column = mots_gtm_jira[TotalTime]

8 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident 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 👍

    • DOLEARY85's avatar
      DOLEARY85
      Resident 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

      • Anonymous's avatar
        Anonymous
        Not applicable

        Still no luck