Easy Question, I want to remove ALL from this command

[RexaZii93]

I have this command:

CALCULATE (

Count ( 'AMS Flights Data'[Arr/ Dep]),

FILTER (

ALL ( 'AMS Flights Data' ),

COUNTROWS (

FILTER (

'AMS Flights Data',

EARLIER ( 'AMS Flights Data'[Actual Date] ) = DATEADD ( 'AMS Flights Data'[Actual Date], -7, Day)

)

)

)

)

Its working fine, but I can't apply any filtering to it, I need to keep the command but remove this part:

FILTER (

ALL ( 'AMS Flights Data' ),

I tried multiple ways but didn't work

Please help

[tamerj1]

Hi @RexaZii93 

Use ALLSELECTED 

[RexaZii93]

I tried Allselected but no data is showing in my chart:

[tamerj1]

@RexaZii93 

You have to use a date table

[RexaZii93]

I have a date table though the formula works fine with out filtering it shows the last 7 days according to the date I use, but when I apply a filter on the chart itself it does not change.

[tamerj1]

@RexaZii93 

Would you please again the frmula you are currently using?

[RexaZii93]

This one:

Count ( 'AMS Flights Data'[Arr/ Dep]),

FILTER (

ALL ( 'AMS Flights Data' ),

COUNTROWS (

FILTER (

'AMS Flights Data',

EARLIER ( 'AMS Flights Data'[Actual Date] ) = DATEADD ( 'AMS Flights Data'[Actual Date], -7, Day)

)

)

)

)

My formula does filter date fine so if I chose any date it would substract 7 days automatically, but when I apply another filter on visual it doesn't effect it I believe the issue is with this part which am unable to remove:

FILTER (

ALL ( 'AMS Flights Data' ),

[tamerj1 · Accepted solution]

@RexaZii93 

Please try

Measure1 =
CALCULATE (
COUNT ( 'AMS Flights Data'[Arr/ Dep] ),
DATEADD ( 'Date'[Date], -7, DAY )
)

[RexaZii93]

I tried but it shows no value and its weird, even without filter this formula shows Blank.

[tamerj1]

@RexaZii93 

Please make sure you're using only the date column from the date table in your visual and slicers. 

[RexaZii93]

Thanks it worked when I used callendar date

[RexaZii93]

I tried but it shows no value and its weird, even without filter this formula shows Blank.