cancel
Showing results for
Did you mean:
Regular Visitor

## Single value from group - Correct sum in visual matrix

Hi,

I have a data table like this:

 Data Product Group Product Value Star Star Alfa 7 Star Star Bravo 7 Star Star Charlie 7 Sun Sun Mike 12 Sun Sun November 12 Sun Sun Oscar 12 Sun Sun Papa 12

I use this measure:

 Measure = CALCULATE(AVERAGE('Data'[Value]);FILTER('Data';'Data'[Sales]=0))

In this matrix:

 Salesman Star Sun Salesman A 7 12 Store 1 7 12 Store 2 7 12

My problem is that though the values for each store is like I want it, I want the vertical sum for Salesman to be 14 and 24. I know that the reason for this is the use of the AVERAGE-function in the measure, but how should I build the measure to get the correct Sum for Salesman, like this:

 Salesman Star SunMeasure Salesman A 14 24 Store 1 7 12 Store 2 7 12

Thanks in advance for any suggestions!

/depple

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

## Re: Single value from group - Correct sum in visual matrix

Hi @depple ,

`Average = SUMX(VALUES(Data_1[Store]),[Measure])`

Best regards,

Yuliana Gu

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

## Re: Single value from group - Correct sum in visual matrix

Hi @depple ,

`Average = SUMX(VALUES(Data_1[Store]),[Measure])`

Best regards,

Yuliana Gu

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