topic Re: get rid of filter for my dax calculation in DAX Commands and Tips

get rid of filter for my dax calculation

reynold522 — Tue, 10 Jan 2023 16:09:58 GMT

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!

Re: get rid of filter for my dax calculation

FreemanZ — Tue, 10 Jan 2023 16:22:38 GMT

hi reynold522

try like:

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

Re: get rid of filter for my dax calculation

tamerj1 — Tue, 10 Jan 2023 16:26:59 GMT

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