DAX Measure to Calculate Average

[chethan]

Hi 

i want to create DAX Measure for to Calculate Average for 2 Columes 

Can you please help me on this

Regards

Chethan  

[v-sihou-msft]

@chethan

When creating measure, DAX need to evaluate with current row context so that you need to aggregate corresponding column value. You can write a measure like below:

Measure =
IFERROR (
    SUM ( Table[G2] )
        / (
            ( SUM ( Table[E2] ) + SUM ( Table[F2] ) )
                / 2
        ),
    0
)

Regards,

[MarkCBB]

Have a look at the Function called AVERAGEX, this will iterate for each row in the table. 

[chethan]

No Can you send the Sample. how to calculate