Forum Discussion
KMEAGHER
Advocate II
Advocate IIReplacing 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 ...
Greg_Deckler
Community Champion
Community ChampionKMEAGHER You could create a measure like this:
Measure = DIVIDE( SUM( 'Table'[STUDENT_COUNT] ), MAX( 'Table'[GROUP_COUNT] ), 0 )