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/
v-basteiMicrosoft Employee
Microsoft EmployeeHi tackytechtom ,
I have hided some irrelevant columns but here is an example for my data:
I would like to show the longest test duration for each test per Log_ID, here you can see one test name per log id but it might be few tests that repeated few time with a different Seed which makes it uniqe, also, build test type should not take in account
I would like to show it as a table just like it shown in the question, inside a PowerBI dashboard, so it probably should be DAX.