sum if contains relationship

[Anonymous]

table_a

ord_pri
money
nr_ped

----------------------------------------

table_b

ord_pri
money
nr_ped

relationship nr_ped

---------------------------------------

SUM valor of table_a
WHERE ord_pri of table_b
CONTAINS ord_pri of table_a

if (table_b.nr_ped CONTAINS table_a.nr_ped)
SUM(table_a.money)

[Eric_Zhang · Accepted solution]

@Anonymous

You can try a measure as below. See more detailis in the attached pbix file.

Measure =
SUMX (
    FILTER (
        TableA,
        CONTAINS (
            SELECTCOLUMNS ( TableB, "ord_pri", RIGHT ( TableB[ord_pri], 2 ) ),
            [ord_pri], CONCATENATE ( TableA[ord_pri], "" )
        )
    ),
    TableA[valor]
)

[Anonymous]

Thank you so much!!!!

[Anonymous]

Ops total = 20