Forum Discussion

freemainia's avatar
freemainia
Icon for Helper I rankHelper I
3 years ago
Solved

COUNTIF measure

Hi,   I would like to: 1. Count the number of IDs that have a "Yes" in any of the corresponding Train cells (answer = 2) 2. Count the number of IDs that don't have a "Yes", but do have a "Partial...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

freemainia's avatar
freemainia
Icon for Helper I rankHelper I
3 years ago

Currently, they are in separate tables.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • freemainia's avatar
    freemainia
    Icon for Helper I rankHelper I
    3 years ago

    Many thanks Ashish_Mathur.

    Seems to be working now, with the slight adjustment of changing:

     
    Measure 3 = COUNTROWS(FILTER(VALUES(Data[ID]),[No count]=3))


    to

    Measure 3 = COUNTROWS(FILTER(VALUES(Data[ID]),[No count trains]=DISTINCTCOUNT(Data[Project])))
     
    Having the value of "3" didn't work when less than 3 projects were selected. I think (hope) the addition of DISTINCTCOUNT(Data[Project]) controls for the number of projects selected.
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      You are welcome.