Find resolved count earlier days

Hi Akshay123 ,

Regarding your question, are you trying to calculate dates based on the first 7 days on the x-axis? For example, if the x-axis is '5/1/2024' and '5/2/2024', the expected result would be to calculate the total number of problems solved in the first 7 days of May 1 and May 2, respectively?

Use the following DAX expression to create a measure.

Measure 2 = 
VAR _a = MAX('incident(2)'[resolved_at])
VAR _b = CALCULATE(COUNTROWS('incident(2)'),FILTER(ALL('incident(2)'),
'incident(2)'[resolved_at] >= _a -6  && 'incident(2)'[resolved_at] <= _a && 'incident(2)'[sys_created_on] >= DATE(2024,1,1)))
RETURN _b

If you just want to count the number of problems solved in the first seven days from today, use the following dax expression.

Measure 3 = CALCULATE(COUNTROWS('incident(2)'),FILTER(ALL('incident(2)'),
'incident(2)'[resolved_at] >= TODAY() -6 && 'incident(2)'[resolved_at] <= TODAY() && 'incident(2)'[sys_created_on] >= DATE(2024,1,1)))