Forum Discussion
Solved
Apply filter to formula
Is there a way to add a formula filter for a certain year to the following equation? I have tried multiple ways but end up with errors. # Count = SUMX( VALUES( 'Table'[Event Title] ) ,CALCULAT...
What do you get if you just apply this:
Measure = Calculate( Distinctcount(Table1[ID]), Calendar[Year] = "2019" )
From my perspective you shouldnt need anything else with the data provided..
This works beautifully thank you so much for your help!
