Replacing duplicate values with 0

[KMEAGHER]

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!

[Greg_Deckler]

@KMEAGHER You could create a measure like this:

Measure = DIVIDE( SUM( 'Table'[STUDENT_COUNT] ), MAX( 'Table'[GROUP_COUNT] ), 0 )