Calculated column - Returns sum while "avg" is desired

[depple]

Hi,

Probably a basic question, but I am lost:

I have created a calculated column for my product data:

DPak-test = CALCULATE('TS-Kuben'[DPak];'TS-Kuben'[Week]=10;'TS-Kuben'[Year]=2019)

In my data table it looks like this for a single product:

In my matrix the calculated column as a value looks like this:

Trouble is, I want it to be 7,98 not 199,50 (which is the sum of all rows for this product in my data table above.

How can I alter the formula for my calculated column, so that the value is 7,98 and not a sum?

Any tips would be highly appreciated.

/depple

[v-danhe-msft]

Hi @depple ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[depple]

Hi @v-danhe-msft ,

I forgot about this post.

Inspired by a suggestion here, the issue was simply solved in the DAX formula using the AVERAGE function.

/depple

[v-danhe-msft · Accepted solution]

Hi @depple ,

Could you have check the "Don't summrize" option:

Regards,

Daniel He