Remove Date filter in Dax (ignore date filter)

[ViralPatel212]

Hi Team,

Wondering if you could help - may be a simple dax edit but i can't see. I have a Previous month measure where it calcuates the Vol size and shows the last month summed value.

Problem: When a person selects a period from the date field. (Sept -Dec) the LAst month measure does a calulation which is correct its not what i am trying to achieve. (showing 982,180.93) (Aug-Nov)

Result: I am trying to make that column/measure static that if some chooses a date filter the measure should ignore it and present the previous month based on Today. Acheive result should be (210,700.89) as im in month Jan 24.

Filter  slicer is coming from a Date table with a relationship to Dealer Ranking (Trade Date) 

Here is how is looks:

Dax:

1) Ranking Size (Vol) previous month =

IF([Ranking Size (Vol)] = BLANK(),BLANK(),

 IF([Ranking Size (Vol)]> 0,

CALCULATE([Ranking Size (Vol)],

PARALLELPERIOD('DIM Calendar (test)'[Date],-1,MONTH))

))

2) Ranking Size (Vol) =

    CALCULATE([Ranking Size], 'Dealer Ranking'[Type] = "Vol. (MM)")

3) Ranking Size =

    SUM('Dealer Ranking'[Size])

thanks

[ViralPatel212]

@AmiraBedh 

I was able to figure it out. Had to create two  for the below dax. My model has got a date table and a custom date table (last 5 day, lasy 7 days, 40 days etc.) so jus changed the dates from the dax to look at the dates and used bookmarks to populate it.

But do you think i could have this in a switch? i.e if 1 filter is selected show measure 2 else if the other show measure 1??

VAR CurrentDate = TODAY()
VAR StartOfCurrentMonth = STARTOFMONTH('DIM Calendar (test)'[Date])
VAR StartOfPreviousMonth = EDATE(StartOfCurrentMonth, -1)
VAR EndOfPreviousMonth = EOMONTH(StartOfPreviousMonth, 0)
RETURN
IF(
    [Ranking Size (Vol)] = BLANK(), 
    BLANK(), 
    IF(
        [Ranking Size (Vol)] > 0,
        CALCULATE(
            [Ranking Size (Vol)],
            ALL('DIM Calendar (test)'),
            'DIM Calendar (test)'[Date] >= StartOfPreviousMonth,
            'DIM Calendar (test)'[Date] <= EndOfPreviousMonth
        )
    )
)

[AmiraBedh]

You need to use ALL() :

Ranking Size (Vol) previous month =
VAR CurrentDate = TODAY()
VAR StartOfCurrentMonth = STARTOFMONTH('DIM Calendar (test)'[Date])
VAR StartOfPreviousMonth = EDATE(StartOfCurrentMonth, -1)
VAR EndOfPreviousMonth = EOMONTH(StartOfPreviousMonth, 0)
RETURN
IF(
    [Ranking Size (Vol)] = BLANK(), 
    BLANK(), 
    IF(
        [Ranking Size (Vol)] > 0,
        CALCULATE(
            [Ranking Size (Vol)],
            ALL('DIM Calendar (test)'),
            'DIM Calendar (test)'[Date] >= StartOfPreviousMonth,
            'DIM Calendar (test)'[Date] <= EndOfPreviousMonth
        )
    )
)

[ViralPatel212 · Accepted solution]

Hi @AmiraBedh  

Thank you for the quick response.

However when i do that. I get a blank data returned?? my table that i need result its broken by a Category so for J.P.Morgan it should show 210,700.89

[AmiraBedh]

Can you share your pbix file ?