Forum Discussion

TrentS's avatar
TrentS
Helper IV
7 years ago
Solved

Should be a Simple Countrows...right?

Afternoon all,   Have been reading and searching trying to figure this one out and still failing. TIme for experts! I have two UNrelated tables. The second table, Month_Count, is for some specific...
Need Help
  • jericacoleman's avatar
    jericacoleman
    7 years ago

    You need to set the count filter so it is only grabbing rows equal to the month on the first column. I would use the following formula to achieve what you are looking for. This is similar to doing a COUNTIF in Excel.

     

    New_Cases = CALCULATE(COUNT(‘Query1’[Month_Open]),FILTER(‘Query1’,'Query1'[Month_Open]='New Table'[Month]))

     

    I didn't know the name of your new table, so I just titled it new table in my formula.

jericacoleman's avatar
jericacoleman
New Member
7 years ago

You need to set the count filter so it is only grabbing rows equal to the month on the first column. I would use the following formula to achieve what you are looking for. This is similar to doing a COUNTIF in Excel.

 

New_Cases = CALCULATE(COUNT(‘Query1’[Month_Open]),FILTER(‘Query1’,'Query1'[Month_Open]='New Table'[Month]))

 

I didn't know the name of your new table, so I just titled it new table in my formula.

  • TrentS's avatar
    TrentS
    Helper IV
    7 years ago

    jericacoleman 

     

    Ah...I got hung up on a Countrows not a simple count.

    Many thanks.

    Happily accepted as a solution!

     

    TrentS