Constant Average

[Anonymous]

Hey guys, I need some help here.

I have to create an average line for each category for the selected period.

I create a measure like this:  

Constant average vendorx = CALCULATE(SUM([Bugs])/DISTINCTCOUNT(Ddate[Date]); FILTER(FCreateClosedWorkItem; FCreateClosedWorkItem[Vendor] = "vendorx"))

But the line respect the date and I want a constant line for the selected period.

What I haveWhat I need

Did I make myself clear?

Thanks for the help.

[yelsherif · Accepted solution]

try adding allselected(FCreateClosedWorkItem) as an additional filter in the calculate function.
It is better to provide sample data to examine the best solution for your case