Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |