Forum Discussion

s15's avatar
s15
Helper III
9 years ago
Solved

Count rows based on a value

I have a list of people with corresponding gender per row as the below screenshot

 

 

Now I need to count number of people by their genders before displaying in Pie chart. For example from my sample, there are 4 female people and 3 male people. What is the dirty and simplest way to do that? I'm a quite new to Power BI.

 

Thank you

 

 

  • I just finally found a solution that I need to count items in FullName column

     

1 Reply

  • s15's avatar
    s15
    Helper III

    I just finally found a solution that I need to count items in FullName column