Forum Discussion
Solved
Changing duplicates into Null
Hi all, I would like to change duplicates in my row into null For example this as my original table, where I would like to change the orange boxes into null as they are replication. ...
jinweitan , better try a measure like
Measure = AVERAGEX(SUMMARIZE (filter('Table 1',not(isblank('Table 1'[Score]))),'Table 1'[GUID],'Table 1'[Type],'Table 1'[Score]),[score])
jinweitan , better try a measure like
Measure = AVERAGEX(SUMMARIZE (filter('Table 1',not(isblank('Table 1'[Score]))),'Table 1'[GUID],'Table 1'[Type],'Table 1'[Score]),[score])