Forum Discussion

sureddy1's avatar
sureddy1
New Member
9 years ago
Solved

dax group by measure

I have a table over which i need to calculate average of a column grouped by multiple columns. I am able to create a table using below:    GROUPBY(tableA,tableA[groupbyA],tableA[groupbyB],"AvgColum...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi sureddy1,

     

    You can create a measure like below:

     

    Measure = CALCULATE(AVERAGE(Table1[Amount]),FILTER(ALLSELECTED('Table1'),'Table1'[Group]=MAX('Table1'[Group]) && 'Table1'[Year]=MAX('Table1'[Year])))

     

     

    You can download attached .pbix file to have a look.

     

    Best Regards,
    Qiuyun Yu

     

     

abhiiimr15's avatar
abhiiimr15
Frequent Visitor
6 years ago

On Similar lines, i need to calculate the avg. score. 

 

SurveyIDParameterSubParameterQuestionScoreScoreatSubParameterlevel     
111Q12.671.8     
111Q211.8     
When I do avg. of Score on Power BI Chart then avg score on Power BI shows 1.5 and not 1.8. Not sure why  

 

Please could any one help on the above scenario. Why does Power BI calculate the wrong avg. for SubParameter=1 .