Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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!