Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average per category

Hi I have data in the following form along with the expected output column (section_1 average per id):     Id QuestionID score section section_1 average per id 1 a 2 1 (2+1)/2=1.5 ...
average
DAX
Filter Multiple Column
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Create a Calculated Column

     

    Section Average =
    var _a = CALCULATE(SUM('Table'[score]), FILTER('Table','Table'[Id] = EARLIER('Table'[Id]) && 'Table'[section] = EARLIER('Table'[section])))
    var _b = CALCULATE(COUNT('Table'[score]), FILTER('Table','Table'[Id] = EARLIER('Table'[Id]) && 'Table'[section] = EARLIER('Table'[section])))

    RETURN

    DIVIDE(_a,_b)
     
     
     
     
    Change formatting of Section Average Column to Decimal
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Create a Calculated Column

 

Section Average =
var _a = CALCULATE(SUM('Table'[score]), FILTER('Table','Table'[Id] = EARLIER('Table'[Id]) && 'Table'[section] = EARLIER('Table'[section])))
var _b = CALCULATE(COUNT('Table'[score]), FILTER('Table','Table'[Id] = EARLIER('Table'[Id]) && 'Table'[section] = EARLIER('Table'[section])))

RETURN

DIVIDE(_a,_b)
 
 
 
 
Change formatting of Section Average Column to Decimal
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)