Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Avoid measure from ignoring slicer using ALL()

Hi. I am trying to display both the current and previous year's sales with a year slicer like so:     I am able to dynamically change the year perperly. Though, I want to be able to select t...
All()
DAX
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Anonymous , you might want to specify column(s) in ALL() function to remove filter(s) on the assigned columns. I think this might do the trick.

    TEST, YTD LY =
CALCULATE (
    [TEST, YTD],
    DATEADD ( Sales[Date], -1, YEAR ),
    ALL ( Sales[Date] )
)
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, Anonymous , you might want to specify column(s) in ALL() function to remove filter(s) on the assigned columns. I think this might do the trick.

TEST, YTD LY =
CALCULATE (
    [TEST, YTD],
    DATEADD ( Sales[Date], -1, YEAR ),
    ALL ( Sales[Date] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks so much! It now works as attended.