Forum Discussion

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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,