Who is the master

Hi mianjalil239 

 

try somthing like this:

EB Avg = 
AVERAGEX (  
    // Iterate over a table created by SUMMARIZECOLUMNS  
    SUMMARIZECOLUMNS (  
        'table'[description],  // Group by 'description' column  
        'table'[batch],        // Group by 'batch' column  
        'table'[coliform],     // Group by 'coliform' column  

        // Define a new column "@value" that calculates the sum of 'table'[EB]  
        "@value", CALCULATE ( SUM ( 'table'[EB] ) )  
    ),  

    // Calculate the average of the "@value" column from the summarized table  
    [@value]  
)  

T