Comparing values from two floating tables

Hi jostnachs - First, you'll want to create a calculated column in the Agreements table to extract the department from the "Description" column.

Department Extracted =
PATHITEM(SUBSTITUTE(Agreements[Description], "_", "|"), 3, TEXT)

Assuming the department is the third part when split by underscores (_), you can use the PATHITEM function after splitting the text.

create a new calculated column in the Agreements table that checks whether the extracted department matches any department in the structure table.

Matched Department =
IF(
COUNTROWS(
FILTER(
Structure,
Structure[Local Department] = Agreements[Department Extracted]
)
) > 0,
1,
0
)

Hope it works to reports as expected 1 or 0

Hi jostnachs 

You can create a measure.

Sum_up =
SUMX ( VALUES ( DimCommissionAgreement[Agreement Description] ), [Measure1] )

Best Regards!

Yolo Zhu

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