Forum Discussion
How to calculate an amount and average using several input rows
Hello! I'm new to the whole Power Bi scene and I was wondering if somebody could maybe help me. I have the following kind of data: Gender Age Score Male 18-25 10 Female 35-45...
Im expecting to get some type of graph showing that there are (for example) two people in the age group 18-25 who scored a 10.
And another graph showing that the average score of that age group is a 10.
The reason that there are dublicate entries is that this data comes from a questionnaire.
Greetings!
Ashish_Mathur
Super User
Super UserHi,
Create a matrix visual. Drag Gender and Score to rows/columns and write this measure
Respondents = countrows(Data)
In another visual, drag Age to the table/matrix visual and write this measure
Average age = average(Data[age])
Hope this helps.
Hello,
I don't quite understand what the measures are supposed to do and where they are supposed to go since Im pretty new to Power Bi.
Could you maybe eleborate on this?Greetings!