Forum Discussion

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

Tips and Tricks

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

Microsoft Employee

8 years ago

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