Forum Discussion

C-Jac's avatar
C-Jac
Icon for Helper I rankHelper I
3 years ago
Solved

ALL does not ignore date filter

I have a model in a star schema.    In the first table I have a couple event, where I have a figure I would like to summarize, both on the period selected but also across all periods, but having re...
all
All()
CALCULATE
sum
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi C-Jac 
    Removing the filter from the Date table will not affect the filters comming the other Dimention Tables.  Using a date hierarchy, means that the filter is comming from different columns (not only the [Date] column) therefore, you need to completely remove the filter from the date table

    Total Revenue Across Time = CALCULATE(SUM('Daily_Revenue'[_Revenue]), ALL(Dim_Calendar))

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi C-Jac 
Removing the filter from the Date table will not affect the filters comming the other Dimention Tables.  Using a date hierarchy, means that the filter is comming from different columns (not only the [Date] column) therefore, you need to completely remove the filter from the date table

Total Revenue Across Time = CALCULATE(SUM('Daily_Revenue'[_Revenue]), ALL(Dim_Calendar))