topic Re: Counting rows with multiple values in a column in DAX Commands and Tips

Counting rows with multiple values in a column

freevission2019 — Sat, 14 Nov 2020 05:18:16 GMT

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

Re: Counting rows with multiple values in a column

wdx223_Daniel — Sat, 14 Nov 2020 07:37:15 GMT

'HR-COA'[Grade] in {49,50,51,52}

Re: Counting rows with multiple values in a column

amitchandak — Mon, 16 Nov 2020 01:18:43 GMT

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"}))

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"))