Forum Discussion

jewels0122's avatar
jewels0122
New Member
3 years ago

Calculating Averages

Hi.  I am trying to calculate an average based on a different field name.  I have a field named "Name" and in it, there are values of "sheet length-3 sheets", "sheet length-6 sheets", etc.  In anothe...
jewels0122's avatar
jewels0122
New Member
3 years ago

Here is a screenshot of the data...I am trying to take the average value, divide it by the sheets based on the name, so for example, the first row, it would take the 36.28 and divide by 6 to give me an average of 6.05

 

Does this help?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi jewels0122 

    please try

    =
    VAR SelectedTable =
    ALLSELECTED ( 'Table' )
    RETURN
    DIVIDE (
    AVERAGE ( 'Table'[Value] ),
    CALCULATE (
    AVERAGE ( 'Table'[LengthMin] ),
    SelectedTable,
    VALUES ( 'Table'[Name] )
    )
    )