Lookup Values and Measures in Matrix Chart

[kkalyanrr]

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)

[v-ljerr-msft · Accepted solution]

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. 

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

Regards