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

Single value from group - Correct sum in visual matrix

Hi,

 

I have a data table like this:

Data  
Product GroupProductValue
StarStar Alfa7
StarStar Bravo7
StarStar Charlie7
SunSun Mike12
SunSun November12
SunSun Oscar12
SunSun Papa12

 

I use this measure:

 

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

 

In this matrix:

 

   
SalesmanStarSun
Salesman A712
   Store 1712
   Store 2712

 

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:

 

   
SalesmanStarSunMeasure
Salesman A1424
   Store 1712
   Store 2712

 

Thanks in advance for any suggestions!

 

/depple

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

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

Hi @depple ,

 

Add below measure into Matrix.

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

1.PNG

 

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.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

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

Hi @depple ,

 

Add below measure into Matrix.

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

1.PNG

 

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.