Only allowed to count time and not sum (hh:nn:ss)

[Anonymous]

Hi,

I want to sum "Talk 3" but when creating graph only count is possible.

Best

Thomas

[Anonymous]

You'll need to make a measure for this to work. 

Try the following > 

Sum of Talk 3 = SUM('Table Name'[Talk 3])

(replace "Table Name" with the name of your table)

Once the measure is created, click onto the measure labelled "sum of Talk 3", then click measuring tools > Format : hh:nn:ss.

[Anonymous]

Thanks for your input. This is working fine when making a card but when making column chart I can't put the measure in values. 

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

The column chart's  ‘Values’ tag can only visualize numeric types, and SUM([Time]) returns a ‘Time’ type, so it cannot be added to the ‘Values’ tag. Try to use a 'Table' visual or a 'Matrix' visual to visualize your time measure.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Please check these blog to sum duration 

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389