Count data

[marisarita93]

Hi everyone, 

I'm new to power BI. I have a question how to count rows that have condition. 

For example I have a table with:

Status: Yes (Y), N (No), No Specified

First Name        Stage 1        Stage 2      Stage 3        Stage 4       Stage 5    Stage 6

abcs                    Y                   Y                    Y                 N              N             N

def                        n        No specified             Y              Y                 Y             Y

yui                         Y                 N                  N           No Specified      N          Y

sdewe          No Specified        Y                     N                  Y                  N        Y

I want to calculate each stage that has total number of Y and total number of N. 

Is there any ways that combine all stages to visualize in one graph? Looks like this picture 

[Barnee · Accepted solution]

Hi @marisarita93,

If you have quite the same original table as your sample one (and if I understood your problem) I would suggest to do the following:

1.) Go to the Query Editor (Home - Edit Queries) - a new window will pop-up

2) Select all the stages in your table and click the Unpivot columns option.

3) In the next step you can rename your columns as Stages and Status, then hit Home - Close and apply. 

4) Now you can count the number of different statuses of the stages and create the visual:

The Query Editor is a pretty useful tool to make transformations and prepear your datasources I suggest you to dive into it 🙂

I hope I could help!

Bests,

Barna