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
chq's avatar
chq
Icon for Helper II rankHelper II
7 years ago

Maybe this will help explain what the desired outcome is



Date      Event Title     # Distinct Count          Week

1/1/19         A                  50                              1

1/3/18         B                  75                              1

7/4/19         X                  99                              4

7/4/18         V                  10                              4

TOTAL                              234

My formula is giving me the # Distinct count correctly, So the above table is fine and already in my report. Below that Table I want to place the following:

Week      Distinct Count 2018          Distinct Count 2019       Difference               %Change
1                         75                                      50                             -25                         -33.33%

4                         10                                      99                              89                           890%


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