get rid of filter for my dax calculation

[reynold522]

Hi All, 

I have a table visual, 

column 1 is IoT ID
column 2 is measure 1

column 3 is measure 2
column 4 is measure 3

I have put a time filter (last 7 days) for the report page. 

I do want Measure 1 and measure 2 filter by time

my measure 3 code is as following:

DoDoverboundaryN =

-- Notification

VAR _Notification =

IF (table[Capacitythreshold])>abs([Max DoD]),0,1)

    RETURN

    _Notification

the code above works, however, I want it not influence by page filter: Table [timestamp]
I used All(table[timestamp], however, I dont know how to integrate this into existing code.

Thanks in advance!

[tamerj1 · Accepted solution]

Hi @reynold522 

I hope both [Capacitythreshold] and [Max DoD] are measures. Please try

DoDoverboundaryN =
CALCULATE (
IF ( [Capacitythreshold] > ABS ( [Max DoD] ), 0, 1 ),
ALL ( 'Table'[timestamp] )
)

[FreemanZ]

hi @reynold522 

try like:

DoDoverboundaryN =
-- Notification
VAR _Notification =
IF (CALCULATE([Capacitythreshold], ALL(TableName[timestamp]))>abs([Max DoD]),0,1)
RETURN
_Notification