Forum Discussion

chq's avatar
chq
Icon for Helper II rankHelper II
7 years ago
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...
Need Help
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

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

  • chq's avatar
    chq
    Icon for Helper II rankHelper II
    7 years ago

    This works beautifully thank you so much for your help!