Forum Discussion

freevission2019's avatar
freevission2019
Helper 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,51, or 52.

 

i wrote this formula but id does not work 😞

YY4 No of SectionHeads = CALCULATE(COUNTROWS('HR'),'HR'[Class]="Supervisor",'HR-COA'[Grade]="49||50||51||52").
 
I appreciate if one can help.
 
Thanx

2 Replies

  • amitchandak's avatar
    amitchandak
    Super 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"))