Forum Discussion

kkalyanrr's avatar
kkalyanrr
Icon for Helper V rankHelper V
8 years ago
Solved

Lookup Values and Measures in Matrix Chart

Hello Team,

 

I'm trying to put a matrix chart  with data from Table B. (Id vs Notes)


When I use Matrix Chart ,  the "Notes(lookup)" values are summed numbers(which is Incorrect, my requeirement is UnSummerized Numbers) ,

 

so I created a measure 

 

Notes(Measure) = SUM(Main[Notes(lookup)])/COUNT(Main[Id])

 

But when I use this measure the Total Value looks incorrect. 

 

I tried to import values from Table 

 

 

Table BMatrix Chart(Using Measure)

Need Help
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi kkalyanrr,

     

    Based on my test, you should be able to use the formula below to create a new measure to get the expected result. :smileyhappy:

    Measure 2 = SUMX(SUMMARIZE(Main,Main[Id],"abc",[Notes(Measure)]),[abc])

     

    Regards

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi kkalyanrr,

     

    Based on my test, you should be able to use the formula below to create a new measure to get the expected result. :smileyhappy:

    Measure 2 = SUMX(SUMMARIZE(Main,Main[Id],"abc",[Notes(Measure)]),[abc])

     

    Regards