Forum Discussion
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...
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
Community Champion
Community ChampionHi jewels0122
please try
=
VAR SelectedTable =
ALLSELECTED ( 'Table' )
RETURN
DIVIDE (
AVERAGE ( 'Table'[Value] ),
CALCULATE (
AVERAGE ( 'Table'[LengthMin] ),
SelectedTable,
VALUES ( 'Table'[Name] )
)
)