Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
4 years ago
Solved

Count with a filter

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!

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    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