Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😞
@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"))
'HR-COA'[Grade] in {49,50,51,52}
User | Count |
---|---|
51 | |
35 | |
19 | |
14 | |
13 |
User | Count |
---|---|
94 | |
72 | |
30 | |
22 | |
14 |