Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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..
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |