Forum Discussion

franorio's avatar
franorio
Helper III
9 years ago
Solved

IF Function 2 conditions, count status

Hello everybody, I have the following question. I have 3 columns: Manager; Scope & Status. Column ¨Manager¨ shows if a person has an employee under his structure... if he has someone, it shows an ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    But in the mean time try this : but add your table name where I have 'Table2'

     

    Measure = CALCULATE(
			COUNTROWS('Table2') , 
			FILTER(
				'Table2',
					'Table2'[Status]="Completed" 
					&& 'Table2'[Scope]="Yes" 
					&& NOT ISBLANK('Table2'[Manager])
					)
				)
Datatouille's avatar
Datatouille
Solution Sage
9 years ago

Hi franorio

 

Try this:

[Measure] = CALCULATE( Countrows(YourTable), not ISBLANK(YourTable[Manager]),YourTable[Scope] = "Yes",YourTable[Status]="Completed")

  • franorio's avatar
    franorio
    Helper III
    9 years ago

    Datatouille Thanks for your reply, but still doesn't work for me.