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...
Ashish_Mathur
Super User
Super UserHi,
What end result are you expecting? Also, why are there duplicate entries for Male 18-25 and Female 50+
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!