Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Is this the normal behavior? - Puzzled by result

Hi all,   I have a simple scenario (see pbix here):   1. Tables:      a. A one-column CalendarTable with the first ten days of 2015      b. A SalesTable with two columns:             [Date]   -...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hi AlB,

     

    on the expanded version of the SalesTable (which includes the Calendar Table as you've mentioned) now you have two columns 'Date', the native one of 'Sales' plus the one coming from 'Calendar'.

    Therefore on the measure:

     

    CALCULATE(SUM(SalesTable[Amount]), ALL(SalesTable[Date]) )

     

    the filter coming from the Slicer (on which you 're using Calendar[Date]) remains active because you're removing the filter only from the 'Date' column that is native to Sales

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Hi AlB,

 

on the expanded version of the SalesTable (which includes the Calendar Table as you've mentioned) now you have two columns 'Date', the native one of 'Sales' plus the one coming from 'Calendar'.

Therefore on the measure:

 

CALCULATE(SUM(SalesTable[Amount]), ALL(SalesTable[Date]) )

 

the filter coming from the Slicer (on which you 're using Calendar[Date]) remains active because you're removing the filter only from the 'Date' column that is native to Sales

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

LivioLanzo

I see what you mean. You're right. I'll mark the post as solution when the feature works again.

Thanks