Forum Discussion

depple's avatar
depple
Icon for Helper III rankHelper III
7 years ago
Solved

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 ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi depple ,

     

    Add below measure into Matrix.

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

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi depple ,

 

Add below measure into Matrix.

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

 

Best regards,

Yuliana Gu