Forum Discussion

hidzirf's avatar
hidzirf
Helper I
4 years ago
Solved

Count row with filter condition

Hello Experts,   I need help. I have a set of data that consist of 12-month data. I already created a measure  AllCount = COUNT(Table[Colum]). Now I would like to create another measure to count ...
Need Help
Show and Tell
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    hidzirf Please try this:-

     

    Measure = CALCULATE(DISTINCTCOUNT('Table (2)'[Number]),FILTER('Table (2)',MONTH('Table (2)'[Date]) = MONTH( TODAY())-1))

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

hidzirf Please try this:-

 

Measure = CALCULATE(DISTINCTCOUNT('Table (2)'[Number]),FILTER('Table (2)',MONTH('Table (2)'[Date]) = MONTH( TODAY())-1))

 

hidzirf's avatar
hidzirf
Helper I
4 years ago

Hi Samarth,

 

I appreciate your help so much. You have always provided me with a solution that has worked. Thanks a lot.