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 remaining filters still active. I have tried below solutions. 

 

Total Revenue Across Time = CALCULATE(SUM('Daily_Revenue'[_Revenue]), ALL(Dim_Calendar[Date]))
Total Revenue Across Time = CALCULATE(SUM('Daily_Revenue'[_Revenue]), ALL(Daily_Revenue[Date]))
 
That is I've tried to use both a date table for my filter, but also just the dates in the original table. There are other dimensions I would like to filter by, so just using ALL on my table rather than the column will not work. 
 
When I insert my date hierarchy, regardless of it is from the Daily_Revenue table or from the Calendar table, it gives me the same result, and still filters by the dates I've selected. 
 
Is there something simple I've missed? 
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))

1 Reply

  • 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))