cancel
Showing results for
Did you mean:
Regular Visitor

## Re: Average for 3 terms in a row

Hi Dale,

I couldn't mange it, when I type this formula it says the formula is too long, and too many values it consists. Have no idea what's wrong. Actually I created very simple measures, such as The Sum of a definite column (measure=Sum (table1(meters)) and so on

Regular Visitor

## Re: Average for 3 terms in a row

..and only

Community Support Team

## Re: Average for 3 terms in a row

Hi @Rustami4,

Could you please share some snapshots of the error messages? Or share the .pbix file directly. A dummy one is enough.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Average for 3 terms in a row

Dale, I liked the idea you described. But could you please make it more clear...look at the attached picI can't get what the encircled values means?! That "sumMeters", i'm typing this and my PBI indicates that's wrong

Regular Visitor

## Re: Average for 3 terms in a row

Actually I'm sure we chose the right direction

Community Support Team

## Re: Average for 3 terms in a row

Hi @Rustami4,

The encircled value is a parameter of Summarize. So you can't use it somewhere else unless you create a table with Summarize.

The second encircled value is a parameter of SUMX, which is inherited from Summarize. How did you use it in your formula?

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Average for 3 terms in a row

Hi, Dale.

How did you define the encircled parameters, I mean is it a separate function or what? Am I supposed to create them separately as a function and after put in the formula above?

Regular Visitor

## Re: Average for 3 terms in a row

Sorry, I randomly clicked "Accept as solution", the issue is still open

Community Support Team

## Re: Average for 3 terms in a row

Hi @Rustami4,

The encircled value is just a column name of the virtual table returned by Summarize. Which step are you in?

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Average for 3 terms in a row

So...the first encircled value is a parameter of sum for 3 distinct parameters (serial, assy,repair), right? I'm just wondering how did you specify the task for it technicially? how this measure function looks