Forum Discussion
v-bastei
Microsoft Employee
Microsoft EmployeeLongest test duration per test name per Log_ID
Hi, I have a table which contains list of tests results. The main columns are: - Log_ID - iteration name - Test - The test name which could be repeated in the same Log_ID multiple times ...
Hi v-bastei ,
How about this:
Here the DAX:
Measure = CALCULATE ( MAX ( Table[Runtime] ), Table[Type] <> "Build", Table[State] = "PASSED" )Does this solve your issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi v-bastei ,
How about this:
Here the DAX:
Measure =
CALCULATE (
MAX ( Table[Runtime] ),
Table[Type] <> "Build",
Table[State] = "PASSED"
)
Does this solve your issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
v-basteiMicrosoft Employee
Microsoft EmployeeLooks like it does.
Thanks!!