cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
depple Regular Visitor
Regular Visitor

Calculated column - Returns sum while "avg" is desired

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:

PBIC2.JPG

 

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

 

PBIC3.JPG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Calculated column - Returns sum while "avg" is desired

Hi @depple ,

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

1.PNG

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Highlighted
Community Support Team
Community Support Team

Re: Calculated column - Returns sum while "avg" is desired

Hi @depple ,

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

1.PNG

Regards,

Daniel He

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

Re: Calculated column - Returns sum while "avg" is desired

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

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

Re: Calculated column - Returns sum while "avg" is desired

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