Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 | |
46 | |
20 | |
16 | |
14 |
User | Count |
---|---|
108 | |
51 | |
30 | |
20 | |
18 |