Sum of rows from Sharepoint List

[andy88]

Hi, 

I am new to PowerBI and wanted to know how to get a sum of the text values of each row from Sharepoint List. 

For example, I have a column named Gender and there will be entries of male or female on each row. I need the sum of the number of entries of males and females. 

Is there a way to do this? Any help would be great? 

[TomMartens]

Hey,

just drag the gender column to the Value pane of your visual and change the aggregation to Count

Hopefully this gets you started.

Regards

Tom

[andy88]

Hey thanks for the quick response.

I have a follow up query where we have a column for example Professionality and the entries are rating values from 1 to 5.  

Do you know how I can show the count of each quantity of value 1,2,3,etc..

[v-piga-msft]

Hi @andy88,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you need further help, please feel free to ask.

Best Regards,

Cherry

[TomMartens]

Hey,

basically it's the same approach change the Aggregation Function from Sum (the default for numerical columns) to count.

This has to be done for each visual.

You can also consider to create a measure like so

Count Something = 
COUNT('yourtablename'[yourcolumnname])

Regards

Tom