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
rafaelmpsantos's avatar
rafaelmpsantos
Icon for Responsive Resident rankResponsive Resident
7 years ago

PLease, can you send some examples with screenshots and the measure used?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

As you can see 2 pics..in 1st pic i have used (Average of task_completion_mins) which is decimal number datatype..it is filtering perfectly based on workflow...In second picture i have used my measure (AvgTurnaroundTimeForTask) it shows other unfiltered data's..

  • 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??