Forum Discussion

jpc's avatar
jpc
Icon for Helper I rankHelper I
5 years ago
Solved

Collating test results from related rows

I have source data tables of Tests and Results.   Some tests have explicit test results, but some don't; in the tests table they are defined as being dependent on other tests.   My objective is to ...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi jpc ,

 

Would you please try to split the dependency into rows by "& " in query editor:

 

 

Then create a new relationship between result table and test table:

 

 

 Create a new column in test table: 

 

Result = IF("Fail" IN CALCULATETABLE(VALUES(Results[Result]),FILTER(Tests,Tests[Calculated Result] = EARLIER(Tests[Calculated Result]))),"Fail","Pass")

 

For more details, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERrFulLwM8pHjyUo9OY5FGoBdi-qi2ZY15lGQxkq01w_zQ?e=gK51Iq

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai