cancel
Showing results for
Did you mean:
New Member

## 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 6
Community Support

Hi @RossBruna12 ,

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.

Community Support

Hi @RossBruna12 ,

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.

Super User

Hi,

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
New Member

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!

Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
New Member

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!