Count with a filter

[nataliesmiy1357]

Hello!  I need some help with my report.  I am trying to count how many courses have the rank of 1, 2, 3 and 4.  I have other filters on the data, so I created a table with the course name and rank.  I need to make a measure calculating how many of those courses are rank 1.  

I tried to create something... but it doesn't work.  I get the count of 1, when I need a count of 10.

Count of Rank 1 = CALCULATE(DISTINCTCOUNT(V_TM_ModulePowerBI[Rank]), FILTER(V_TM_ModulePowerBI, V_TM_ModulePowerBI[Rank] = 1))

Thanks in advance!

[Samarth_18 · Accepted solution]

HI @nataliesmiy1357 

Please try this:-

Count of Rank 1 = CALCULATE(DISTINCTCOUNT(V_TM_ModulePowerBI[course name]), FILTER(V_TM_ModulePowerBI, V_TM_ModulePowerBI[Rank] = 1))

Thanks,

Samarth