How to group by transaction ID and Tag

[jbuzaglu]

Hi all, so I have a unit table that brings sales data (including item IDs on each transaction, so I may have more than 2 rows per transactions). I have already grouped by transactions on another table, but I need to create a column on the other table thats tags whether a transaction contains a unit that was "yes" for GWP. So basically, when one of the units inside a transaction has GWP "Yes", that transaction should be classified as GWP transaction.

[jbuzaglu]

THANK YOU SO MUCH!!!! This worked like a charm!!!

[sevenhills]

Glad it worked 😊

[jbuzaglu]

[sevenhills · Accepted solution]

For a column, you can try like this?

Is GWP Transaction = 

var _TxID = 'Table1'[Transaction Number]
var _IsGWP = IF ( COUNTROWS( FILTER( all('Table1'), 'Table1'[Transaction Number] = _TxID && 'Table1'[GWP Unit] = "Yes")) > 0, "Yes", "No")

Return _IsGWP