Unmatched Row count with aggregation with Region

Hi Microblog321 ,

Please check if this could meet your requirements:

unmatched Taskid Count =
VAR t =
    DISTINCT (
        SUMMARIZE (
            EXCEPT (
                SUMMARIZE ( 'Table 1', 'Table 1'[Taskid], 'Table 1'[Region] ),
                SUMMARIZE ( 'Table 2', 'Table 2'[Taskid], 'Table 2'[Region] )
            ),
            [Taskid]
        )
    )
RETURN
    COUNTX ( t, [Taskid] )

matched Taskid Count = 
VAR t =
    DISTINCT (
        SUMMARIZE (
            INTERSECT (
                SUMMARIZE ( 'Table 1', 'Table 1'[Taskid], 'Table 1'[Region] ),
                SUMMARIZE ( 'Table 2', 'Table 2'[Taskid], 'Table 2'[Region] )
            ),
            [Taskid]
        )
    )
RETURN
    COUNTX ( t, [Taskid] )

Best Regards,

Icey

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