Forum Discussion

Kish1999's avatar
Kish1999
Icon for Helper II rankHelper II
2 years ago

Find score for a department in a program

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:

ProgramDepartmentScore
   
101a4
101a3
101a3
101b3
101b3
102a2
102a3
102b5
102b3
102b3
103a2
103a3
103b1
103b2

Result:

ProgramCount
1012
1021
1030
Need Help

1 Reply

  • OguzMavice's avatar
    OguzMavice
    Icon for Resolver II rankResolver II
    2 years ago

    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 ;

     

    Count_Calc =
    CALCULATE(
        COUNTROWS(
            FILTER(
                VALUES('program'[departments]),
                CALCULATE(MIN('program'[score])) = 3
            )
        )
    )
    result will be like that ; 
     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.