cut a measure at today?

[Anonymous]

Alright, so im pretty sure im just being an idiot, i have the below measure, but i only wanty it to display data up to todays date for this measure, and have the other measure carry on, is there a way to cut this with a Today() somewhere?

actual = COUNTROWS(

FILTER(

ALL('Bespoke Review Task List'),

'Bespoke Review Task List'[Model]="TEXT"

&& 'Bespoke Review Task List'[Status] <> "Rejected"

&& NOT(ISBLANK('Bespoke Review Task List'[Accepted Date]))

&& 'Bespoke Review Task List'[vehicle usage] <> "TEXT"

&& 'Bespoke Review Task List'[vehicle usage] <> "TEXT"

&& 'Bespoke Review Task List'[Sales Order] <> ""

&& 'Bespoke Review Task List'[Sales Order] <> "n/a"

&& 'Bespoke Review Task List'[Accepted Date] <= MAX('Calendar'[Date]

)

))

[harshnathani]

Hi @Anonymous ,

See if this works

actual =
COUNTROWS (
    FILTER (
        ALL ( 'Bespoke Review Task List' ),
        'Bespoke Review Task List'[Model] = "TEXT"
            && 'Bespoke Review Task List'[Status] <> "Rejected"
            && NOT (
                ISBLANK ( 'Bespoke Review Task List'[Accepted Date] )
            )
            && 'Bespoke Review Task List'[vehicle usage] <> "TEXT"
            && 'Bespoke Review Task List'[Sales Order] <> ""
            && 'Bespoke Review Task List'[Sales Order] <> "n/a"
            && 'Bespoke Review Task List'[Accepted Date]
                <= MAX ( 'Calendar'[Date] )
            && 'Bespoke Review Task List'[Accepted Date]
                >= TODAY ()
    )
)

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Anonymous]

Nope, that sets the whole measure to blank

[Anonymous · Accepted solution]

Ohh, i am an idiot,.

new column on the dataset

is future = if(

'Calendar'[Date] > TODAY(),

TRUE(),

FALSE()

)

Then amend the measure to

actual = CALCULATE(COUNTROWS(

FILTER(

ALL('Bespoke Review Task List'),

'Bespoke Review Task List'[Model]="TEXT"

&& 'Bespoke Review Task List'[Status] <> "Rejected"

&& NOT(ISBLANK('Bespoke Review Task List'[Accepted Date]))

&& 'Bespoke Review Task List'[vehicle usage] <> "text"

&& 'Bespoke Review Task List'[vehicle usage] <> "text"

&& 'Bespoke Review Task List'[Sales Order] <> ""

&& 'Bespoke Review Task List'[Sales Order] <> "n/a"

&& 'Bespoke Review Task List'[Accepted Date] <= MAX('Calendar'[Date]

)

)),'Calendar'[is future] = FALSE())