Finding row values for last 8 days based on measure & expression calculating the difference in days

[Coffee2023]

Hi, I need to find the Events Delta (Delta Column in picture below) from the last 8 days, based on my measure calculation created for # of Events and Create Date Difference expression, which calculates the difference in days between my create date and today.

Example of wanted outcome: 

# of Events = COUNTROWS(FILTER(vw_table,vw_table[COTypeName] = "Event"))

Create Date Difference = DATEDIFF('vw_table'[CreateCODate], TODAY(), DAY)

Current Errored Delta Forumla: 

Delta = CALCULATE(SUMX('vw_table, 'vw_table[# of Events], FILTER('vw_table,'vw_table[Create Date Difference] < 8)))

Thank you in advance for your help!

[Anonymous · Accepted solution]

Hi @Coffee2023 ,

Unable to see the details of your error .

I assumed some data:

Use the following DAX expression to create a measure

Delta = 
VAR _result = COUNTROWS(FILTER('vw_table','vw_table'[COTypeName] = "Event" && 'vw_table'[Create Date Difference] < 8)) 
RETURN IF(ISBLANK(_result),0,_result)

Final output

Best Regards,
Wenbin Zhou