Create new table using another table

[Anonymous]

Hi, I am trying to groupby a table and want to create new table from that:

From the above dummy tableI want to create  the below table 'AggregatedTable', "NoofTest" is count of all rows coming after grouping, "PassTests" column will contain count of those row whenever TABLENAME['DIFFERENCE'] will be zero. I am getting error for the below code, how to resolve it?
AggregatedTable =

GROUPBY( TABLENAME, TABLENAME[Source], TABLENAME[KPI],

 "NoOfTests", COUNTX(CURRENTGROUP(), COUNTROWS(TABLENAME)), "PassTests",COUNTX(CALCULATETABLE(TABLENAME,TABLENAME[Difference]=0),COUNTROWS(TABLENAME)) )

[v-weiyan1-msft · Accepted solution]

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.

[Anonymous]

It worked! Thanks

[ryan_mayu]

@Anonymous 

what's the expected output based on the sample data you provided?

could you pls provide a table of output as well?

[jjrand]

Hi, can you please post your data in a way that's easy to copy and paste? Your question would be more likely to get answered.

See here

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...0