Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Gokul
Helper IV
Helper IV

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) 

5 REPLIES 5
rafaelmpsantos
Responsive Resident
Responsive Resident

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

1.png2.pngAs 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..

@rafaelmpsantos any idea ?

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

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

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.