Create new table using another table

Hi Anonymous ，

Based on the sample and description you provided, Please try code as below.

AggregatedTable = 
            ADDCOLUMNS(
                       GROUPBY(
                       TABLENAME,
                       TABLENAME[Source], 
                       TABLENAME[KPI],
                       "NoofTest", COUNTX(CURRENTGROUP(),COUNTROWS(TABLENAME))
                    ),
                        "PassTests", COUNTX(CALCULATETABLE(TABLENAME,TABLENAME[Difference]=0),COUNTROWS(TABLENAME)) 
                    ) 

Result is as below.

Best Regards,
Yulia Yan

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