Custom Dax table combining measures from 3 tables

Hi jchww ,

I tested the process as follows.

Connecting to a data source.

Make change to this mode. (Bottom right corner of the screen)

Please create a new table. Where 'Risks'[Status] = "(1) Active", "(1) Active" can be replaced with any text you need.

Table =
SUMMARIZE (
    'Projects',
    'Projects'[Project Name],
    "Count(Issues)", COUNTROWS ( 'Issues' ) + 0,
    "Count(Risks) Where Status like 'Mitigated'", CALCULATE ( COUNTROWS ( 'Risks' ), 'Risks'[Status] = "(1) Active" ),
    "Count(Risks) Where Status not like 'Mitigated'", CALCULATE ( COUNTROWS ( 'Risks' ), 'Risks'[Status] <> "(1) Active" )
)

Table.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data