How to count 2 different values within a column

[DL]

Hi,

I am trying to write a DAX formula to count the number of 2 different values in a column.

I want to obtain a count of "Responsible Team"- Team 1 , that have had  "Day Open Grouped"- Between 35 Days and 1 year, and Over 1 Year.

So in this instance , the count would be 9. (8= Between 35 Days and 1 year, 1= Over 1 Year)

Responsible Team       Days Open Grouped

Team 1	Less than 35 days
Team 1	Between 35 Days and 1 year
Team 1	Between 35 Days and 1 year
Team 1	Less than 35 days
Team 1	Between 35 Days and 1 year
Team 1	Between 35 Days and 1 year
Team 1	Over 1 year
Team 1	Less than 35 days
Team 1	Between 35 Days and 1 year
Team 1	Between 35 Days and 1 year
Team 1	Between 35 Days and 1 year
Team 1	Between 35 Days and 1 year

Thanks, DL

[SteveCampbell · Accepted solution]

Hello,

You can try:

Count Measure = 

CALCULATE(
    COUNTROWS(Table1)
    ,Table1[Responsible Team]="Team 1"
    ,Table1[Days Open Grouped] in {"Between 35 Days and 1 year", "Over 1 year" }
)

and change Table1 to your table name.

[DL]

Thank you- it worked!