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...
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

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