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.
Hello All,
we have a requirement where we need to find the Count of department in a program where the Minimum of the score is "3".
So, suppose if have a program in which there are two departments and there are three entries(scores) in the department. We need to find out if the Minimum score for that department is 3 or not, and if the min score is 3 then count that program.
Can you please help us write this measure.
sample dataset:
Program | Department | Score |
101 | a | 4 |
101 | a | 3 |
101 | a | 3 |
101 | b | 3 |
101 | b | 3 |
102 | a | 2 |
102 | a | 3 |
102 | b | 5 |
102 | b | 3 |
102 | b | 3 |
103 | a | 2 |
103 | a | 3 |
103 | b | 1 |
103 | b | 2 |
Result:
Program | Count |
101 | 2 |
102 | 1 |
103 | 0 |
Hi @Kish1999 , in order to reach this result we should filter values which are equal to 3 as min score and count all of them concerning department. And we will do all process in measure.
Could you please try below dax code ;
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |