Forum Discussion

Jos13's avatar
Jos13
Helper III
5 years ago
Solved

Cannot format measure

Hi All, I was trying to format total duration in hh:mm:ss format in a matrix visual. I wanted to show those employees with duration>100 sec or transactions>20.  I could create a measure for ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Jos13 ,

     

    Please try this:

    Measure = 
var _hour=TRUNC([Total Duration]/3600)
var _min= TRUNC(  MOD([Total Duration],3600)  /60)
var _sec=MOD( MOD([Total Duration],3600),60)
return IF([Total Duration]>100 || [Total Transactions]>20 , TIME(_hour,_min,_sec),BLANK())

    After uncheck the Show items with no data options, the final output is shown below:

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

Jos13 , for duration first have measure

 

Total duration = sum(Table[duration])

 

Duration as Duration =Quotient([Total duration ],3600) &":" & Quotient(mod([Total duration ],3600),60) &":" & mod(mod([Total duration ],3600),60)

 

Filter > 100

 

Sumx(filter(summarize(Table, Table[reporting to] , Table[Employee], "_Duration" , [Total duration],"_trans",[Total Transactions] ) , _Duration >100 && _trans >20),[_Duration])

 

Again use the duration code