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 | 5 |
| Female | 50+ | 0 |
| Male | 26-34 | 5 |
| Female | 50+ | 0 |
| Male | 18-25 | 10 |
And is was wondering two things:
1. Is it possible (and how) to get a visualisation that shows for each age group what the amount of people are that scored a certain score?
2. Is it possbile (and how) to get a visualisation that shows for each age group what the average score of that age group is?
Does anybody maybe know how to do this?
Greetings!
6 Replies
- Ashish_Mathur
Super User
Hi,
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!
- Ashish_Mathur
Hi,
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.
Hi Anonymous ,
Please have a try.
Create a table to delete repeat value.
Table 2 = DISTINCT('Table')Create a measure to calculate the average.
Measure = CALCULATE(AVERAGE('Table 2'[Score]),FILTER(ALL('Table 2'),'Table 2'[Age]=SELECTEDVALUE('Table 2'[Age])&&'Table 2'[Gender]=SELECTEDVALUE('Table 2'[Gender])))If I misunderstood your meaning, please provide more details and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
