Convert excel (IF(ISERROR(AVERAGEIFS) to DAX

Hi Anonymous

In Editor Queries

merge columns for table P (MAT, WORLD,LINE)

and for table C(MAT, PLANNING,LINE)

 

Then "apply&close", create a relationship between two tables

 

Finally create measures in Table P

sum = CALCULATE(SUM(P[UP]),FILTER(ALL(P),[Merged]=MAX(C[Merged])))

count = CALCULATE(COUNT(P[UP]),FILTER(ALL(P),[Merged]=MAX(C[Merged])))

average1 = [sum]/[count]

Or

Measure =
VAR sum1 =
    CALCULATE ( SUM ( P[UP] ), FILTER ( ALL ( P ), [Merged] = MAX ( C[Merged] ) ) )
VAR count1 =
    CALCULATE (
        COUNT ( P[UP] ),
        FILTER ( ALL ( P ), [Merged] = MAX ( C[Merged] ) )
    )
RETURN
    IF ( MAX ( P[Merged] ) = MAX ( C[Merged] ), sum1 / count1, "no trial" )

 

Best Regards

Maggie