What the heck is the problem?

[Anonymous]

Hello,

I have a measure to sum the duration of minutes to hours. The problem is, its working perfect but only as a table or matrix?! I can not put the measure to the fiel values to make eg. a bar chart. How can I fix this? And I also cant change the data type of the measure. (It is text)

Zeitaufwand Delegation/Gruppen =

VAR TotalSeconds=SUMX('Zeitaufwand Bewirtungen',HOUR('Zeitaufwand Bewirtungen'[Zeitaufwand Delegation/Gruppen])*3600+MINUTE('Zeitaufwand Bewirtungen'[Zeitaufwand Delegation/Gruppen])*60+SECOND('Zeitaufwand Bewirtungen'[Zeitaufwand Delegation/Gruppen]))

VAR Days =TRUNC(TotalSeconds/3600/24)

VAR Hors = TRUNC((TotalSeconds-Days*3600*24)/3600)

VAR Mins =TRUNC(MOD(TotalSeconds,3600)/60)

VAR Secs = MOD(TotalSeconds,60)

return IF(DAYS=0,"",IF(DAYS>1,DAYS&"days ",Days&"day"))&IF(Hors<10,"0"&Hors,Hors)&":"&IF(Mins<10,"0"&Mins,Mins)&":"&IF(Secs<10,"0"&Secs,Secs)

[Anonymous · Accepted solution]

Hi @Anonymous ,

As @HotChilli said, your measure returns a text which could not be plotted on a chart(Y-axis) .

So you could only apply TotalSeconds to Y-axis instead because it is a number value . And then drag your measure to Tooltips.

Or you could change TotalSeconds to Duration in Power Query as shown below:

Output:

Or refer to this blog:https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639

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

[HotChilli]

 TotalSeconds is the only one that is correct for the whole total

The other variables all work from TotalSeconds -> the final result is a text representation of TotalSeconds split into Days,Hours,Minutes,Seconds.

I haven't looked at in detail but it seems right.  You have to decide what you want to return.

[HotChilli]

Presumably this is because the measure returns a text representation D:H:M:S .  You can't add this with another value - it doesn't make sense.

You might have a chance if you return a number (seconds, minutes or whatever)

[Anonymous]

How can I return a number? I found the Measure on the internet, I'm not a DAX Expert 😄