To make a column where it checks if the multiple tender from the next table are both similar

Hi all,

So i have a column in the Document Table of a report which tells what tender was used for the transaction based on another column named Tender Type.

So if the tender type is 6 then the Transaction has split tender.

The issue is even if the cashier is giving the change for the cash, it will come in split tender.

There's another table called Tender which records the tender information in individual rows.

So the expected output is, even if the cashier is taking the cash and giving out change, it should show as Cash tender instead of Split tender.

The document table and the tender Table are related by Document SID using one to many type of relation..

Can i write a condition in document table column to check the multiple rows of the tender table with the same document sid for the tender type and return the result.?

I'm uploading the pbix file in this Wetransfer link.

Thanks for your help in advance.