Forum Discussion

franorio's avatar
franorio
Icon for Helper III rankHelper 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])
					)
				)
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Can you please post a small sample of your data?

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    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])
					)
				)
    • franorio's avatar
      franorio
      Icon for Helper III rankHelper III
      9 years ago

      Thanks a lot Phil!! worked perfectly!!