Calculations using 2 datasets(tables)

Hi, BSM1985 

It’s my pleasure to answer for you.

If you just want to group by columnA, and add up to get the number that meets the two conditions (columnA=column1 and columnc="Q"),

Like this:

You can try it(First, create the relationship between the two tables):

Measure:

Qnumbers =
COUNTROWS (
    FILTER (
        DATASET1,
        AND (
            DATASET1[COLUMNA] = RELATED ( DATASET2[COLUMN1] ),
            DATASET1[COLUMNC] = "Q"
        )
    )
)

If it doesn’t meet your requirements, could you please share what your expected results and share some sample data ?

Best Regards

Janey Guo

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