Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Constant Average

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.

Need Help
Show and Tell
  • yelsherif's avatar
    yelsherif
    7 years ago

    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

1 Reply

  • yelsherif's avatar
    yelsherif
    Resolver IV
    7 years ago

    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