How to calculate an amount and average using several input rows

[RossBruna12]

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!

[v-rongtiep-msft]

Hi @RossBruna12 ,

Did my answer solve your problem? Or maybe you've already solved the problem. If so, please share your process with us.

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.

[v-rongtiep-msft]

Hi @RossBruna12 ,

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.

[Ashish_Mathur]

Hi,

What end result are you expecting?  Also, why are there duplicate entries for Male 18-25 and Female 50+

[RossBruna12]

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.

[RossBruna12]

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!