Forum Discussion

3 Replies

  • MarkCBB's avatar
    MarkCBB
    Icon for Helper V rankHelper V
    9 years ago

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

    • chethan's avatar
      chethan
      Icon for Resolver III rankResolver III
      9 years ago

      No Can you send the Sample. how to calculate 

  • 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,