Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

measure filter is not working

i have two tables .. one is group and other is task... (one to many relationship).. when i used my measure in matrix table it is not filter based on my firdt table(group) 
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

rafaelmpsantos any idea ?

rafaelmpsantos's avatar
rafaelmpsantos
Icon for Responsive Resident rankResponsive Resident
7 years ago

Show the measure created to do this. I think the problem is average of TIME.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    rafaelmpsantos

    Measure 

    AvgTurnaroundTimeForTask = var dayNo=INT(AVERAGE(Query1[task_completion_mins])/1440)
    var hourNo=INT(MOD((AVERAGE(Query1[task_completion_mins])),1440)/60)
    var minuteNO=MOD(MOD((AVERAGE(Query1[task_completion_mins])),1440),60)
    var days=if(dayNo>1,dayNO&" Days ",if(dayNo=1,dayNO&" Day "))
    var hrs=if(hourNo,FORMAT(hourNo,"#0")&" Hrs ",if(hourNo=1,FORMAT(hourNo,"#0")&" Hr "))
    var mins=if(minuteNO>1,FORMAT(minuteNo,"#0")&" Mins",if(minuteNO=1,FORMAT(minuteNo,"#0")&" Min",if(minuteNO=0,"")))

    return CONCATENATE(days,CONCATENATE(hrs,mins))
    rafaelmpsantos any other reequirements needed??