Forum Discussion
Measure to Count Rows that Meet Two Criteria
I have a table that contains three primary columns - Location (Text), Event Type (Text) and Event Value (Number). I have been trying to define a measure that will count the number of rows that meet s...
Hi,
You can use FILTER combined with countrows.
E.g.
Measure = COUNTROWS(FILTER(table,column1=state1&&column2=state2&&column3=state3))
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!