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 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
Solved! Go to 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
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
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 |
---|---|
106 | |
96 | |
79 | |
65 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |