Forum Discussion
Solved
Formula
Hi, I am trying to pull back the count of the account in another table, but also include a filter to select the date. Currently for the count, it is just bringing back a total instead of it...
You could use
Jan'25 = CALCULATE ( COUNTROWS ( Event ), FILTER ( Event, Event[Account Name] = Test[Name] && Event[Activity Date (Month Year)] = "Jan 2025" ) )
As you're creating a calculated column you have a row context, not a filter context, and SELECTEDVALUE only works in a filter context. Just replace the SELECTEDVALUE with Test[Name] and it should work.