Find score for a department in a program

[Kish1999]

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

[OguzMavice]

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.