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. ...
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

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