Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Countifs conditions in the same column

Hello 
 
Can someone correct the below synthax? I need to have 3 conditions based on the same column. I am getting the count correct when I apply the first condition that is Project Status = Cap Pro Ongoing, but when i enter my other 2 conditions the measure is returning blank, with no synthax error.
 
Thanks
Fanis
 
Count Active Projects = CALCULATE(COUNTX(Tracker,COUNT(Tracker[PPM ID])), Tracker[Project Status]="Cap.Pro. - Ongoing",Tracker[Project Status]="Cap.Pro. - Completed")
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Try: Count Active Projects = CALCULATE(COUNT(Tracker[PPM ID]), FILTER(Tracker, Tracker[Project Status]="Cap.Pro. - Ongoing" || Tracker[Project Status]="Cap.Pro. - Completed"))

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous Try: Count Active Projects = CALCULATE(COUNT(Tracker[PPM ID]), FILTER(Tracker, Tracker[Project Status]="Cap.Pro. - Ongoing" || Tracker[Project Status]="Cap.Pro. - Completed"))