March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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)
PLease, can you send some examples with screenshots and the measure used?
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..
Show the measure created to do this. I think the problem is average of TIME.
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??
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |