Forum Discussion

freevission2019's avatar
freevission2019
Icon for Helper I rankHelper I
5 years ago

Counting rows with multiple values in a column

Hi, I am working on data for HR and I want to calculate the No. of section heads. two columns determine this classification. the  class = "Supervisor" and the other column is grade  = can be 49, 50,5...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

freevission2019 , one of the two ways

YY4 No of SectionHeads = CALCULATE(COUNTROWS('HR'),'HR'[Class]="Supervisor",filter('HR-COA'[Grade], 'HR-COA'[Grade] in{"49","50","51","52"}))

or

YY4 No of SectionHeads = CALCULATE(COUNTROWS('HR'),'HR'[Class]="Supervisor",filter('HR-COA'[Grade] , 'HR-COA'[Grade]="49" || 'HR-COA'[Grade]= "50"
'HR-COA'[Grade] = "51" 'HR-COA'[Grade] ="52"))