Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

AVERAGEX help needed

Hello Experts, looking for some guidance or help in calculating Average Unit rate values based on 2 conditions (ID num, Doc Num). If I had to do it in excel, I can simply use AVERAGEIFS, which I beli...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Try

     

    Avg_Unit_Rate =
IF (
    TableName[Touch Point] = "Main",
    CALCULATE (
        AVERAGE ( TableName[Avg Unit Rate] ),
        ALLEXCEPT ( TableName, TableName[ID Number], TableName[Doc Number] )
    )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Also, I need these 2 to be on as calculated columns instead of measures, as I have a few more further columns being calculated depended on the unit rate and qty consumed. 

 

AVERAGEX is used to calculate the average a table using line by line calculation example, you wanted to make the sum of all the Av Unit rate within ID number and of that make the average.

that is exactly what I need.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Try

 

Avg_Unit_Rate =
IF (
    TableName[Touch Point] = "Main",
    CALCULATE (
        AVERAGE ( TableName[Avg Unit Rate] ),
        ALLEXCEPT ( TableName, TableName[ID Number], TableName[Doc Number] )
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Zubair_Muhammad - thanks a bunch for your response. Would this be a measure or a calculated column ?

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago
      hi

      It is a calculated column
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Nice!!! I will try and let you know. Thanks again for your help.