Rolling average of count of category

[mithun41]

Rolling average of count

26m ago

Issue created	Category	issues
01-02-2022	Customer	title1
01-02-2022	Internal	title2
04-02-20322	Customeer	title3

I have table like this above, I need to calcualte the rolling average of last 12 weeks of Percentage of Customer issues / vs total issues(Customer+Internal). Can anybody help with calcuation of the measure  . I tried this 

[Anonymous · Accepted solution]

Hi @mithun41 ,

Here's my solution.

You could create a measure for this.

Measure = var _count=CALCULATE(COUNT('Table'[Category]),FILTER(ALLSELECTED('Table'),[Category]="Customer"&&[Issue created]>MAX('Table'[Issue created])-12*7&&[Issue created]<=MAX('Table'[Issue created])))
var _all=CALCULATE(COUNT('Table'[Category]),FILTER(ALLSELECTED('Table'),[Issue created]>MAX('Table'[Issue created])-12*7&&[Issue created]<=MAX('Table'[Issue created])))
return DIVIDE(_count,_all)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[mithun41]

@tamerj1 

[mithun41]

Any help ?