Forum Discussion
Countrows with multiple filters
Hi, I have a table with multiple question numbers and answers that range from 1 to 7. I would like to create a measure that counts the number of rows where the answer for a specific question is equal to 6 or 7.
For example, for this table, I’d like to count the number of times question Q15 was 6 or 7. The answer should be 3
Question Number | Answer |
Q13 | 4 |
Q13 | 6 |
Q14 | 3 |
Q14 | 7 |
Q15 | 7 |
Q15 | 6 |
Q15 | 2 |
Q15 | 5 |
Q15 | 6 |
Hi, juliaellershaw
You can try this measure:
Count = CALCULATE(COUNT('Table'[Question Number]),FILTER('Table',[Question Number]="Q15"&&[Answer] in {6,7}))And place this measure into a card chart, you can get the value 3, like this:
This is my test pbix file
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, juliaellershaw
You can try this measure:
Count = CALCULATE(COUNT('Table'[Question Number]),FILTER('Table',[Question Number]="Q15"&&[Answer] in {6,7}))And place this measure into a card chart, you can get the value 3, like this:
This is my test pbix file
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you are going to place the Questions on a Table Visual, you can use the following measure which will count based on each Question.
Count Measure = CALCULATE( COUNTROWS( Table ), Table[Answer] IN {6,7} )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
