Forum Discussion

DL's avatar
DL
Frequent Visitor
7 years ago
Solved

How to count 2 different values within a column

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 1Less than 35 days
Team 1Between 35 Days and 1 year
Team 1Between 35 Days and 1 year
Team 1Less than 35 days
Team 1Between 35 Days and 1 year
Team 1Between 35 Days and 1 year
Team 1Over 1 year
Team 1Less than 35 days
Team 1Between 35 Days and 1 year
Team 1Between 35 Days and 1 year
Team 1Between 35 Days and 1 year
Team 1Between 35 Days and 1 year

 

 

Thanks, DL

Need Help
  • SteveCampbell's avatar
    SteveCampbell
    7 years ago

    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.

2 Replies

  • SteveCampbell's avatar
    SteveCampbell
    Memorable Member
    7 years ago

    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's avatar
      DL
      Frequent Visitor
      7 years ago

      Thank you- it worked!