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 a...
Need Help
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.