Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count IF Dax Formula

Hello, I'm trying to count the number of lawyers ( distinct timekeeper ID's) that have more than 500 attorney hours.     My graph below shows the count of all distinct timekeeper ID's, but I would ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like 

    countX(filter(summarize(Table[TimeKeeper ID],"_1",sum(Table[Hour])),[_1]>=500),[TimeKeeper ID])

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try

countX(values(Table[TimeKeeper ID]),if(sum(Table[Hour])>=500,[TimeKeeper ID],blank()))

countX(filter(summarize(Table[TimeKeeper ID],"_1",sum(Table[Hour])),[_1]sum(Table[Hour])),[TimeKeeper ID])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandakassuming these are two different options.  I tried the first but got the same results:

 

countX(values(Table[TimeKeeper ID]),if(sum(Table[Hour])>=500,[TimeKeeper ID],blank()))

 

I gotet the following error with the second formula:

 

 

 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Try like 

    countX(filter(summarize(Table[TimeKeeper ID],"_1",sum(Table[Hour])),[_1]>=500),[TimeKeeper ID])