Add Average Function into Summarize

[Anonymous]

Hi Experts

I want the average of a particular column in the following DAX

Summary = filter ( Summarize (Input[Year],Input'[M Column],Average(Input[Addtion]/2), Input[Terms]), Input[Terms] = "BTMT")

Adding the Average(Input[Addtion]/2) gives and error.

[Jihwan_Kim]

Hi,

please try the below.

Summary = filter ( Summarize (Input[Year],Input'[M Column], "@newcolumn", Average(Input[Addtion]/2), Input[Terms]), Input[Terms] = "BTMT")

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Anonymous]

Hi Kim error from this point onwards (Input[Addtion]/2), Input[Terms]), Input[Terms] 

[Jihwan_Kim · Accepted solution]

Hmm

can you please try to replace the above with the below?

(input[adition])/2, input[terms]),input[terms]

[Anonymous]

Nope...Kim

[Jihwan_Kim]

please share the sample pbix file, if possible.

That will be very much helpful for me to come up with a more accurate measure.

[Anonymous]

"RT",(Average(input[Additon])/2), works but error ,Input[Terms]),Input[Terms]="BTMT")