Forum Discussion
Replacing duplicate values with 0
Hello, in the example below I am trying to visualize the amount of students (STUDENT_COUNT) as a percentage of the total group (GROUP_COUNT) for each distinct GROUP_BY_VALUE, however the GROUP_COUNT is duplicated for each distinct TEST_RESULT and GROUP_BY_VALUE combination. For example, in the first two rows, for Eng Prof students I want to display (118+386)/1267 not 2534. Any suggestions on how to replace the duplicate GROUP_COUNTS with zeros? Or another solution? Thanks!
1 Reply
KMEAGHER You could create a measure like this:
Measure = DIVIDE( SUM( 'Table'[STUDENT_COUNT] ), MAX( 'Table'[GROUP_COUNT] ), 0 )
