Countrows with multiple filters

[juliaellershaw]

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

[Fowmy]

@juliaellershaw 

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 🙂

Website YouTube  LinkedIn

[v-robertq-msft · Accepted solution]

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.