Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Trying to Replicate a Total in a Measure

I am trying to create a measure that replicates the total value in this table: The total fluctuates as filters are applied and I would need the measure to do the same. Ultimately I will ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I have solved this, thank you for the input. The two measures needed: 

     

    Top10 Program Total =
    var A = SUMMARIZE('TE',[program],"Enrollment",SUM('TE'[    student_flag])) 

    var Top10 = TOPN(10,A,[Enrollment],DESC)
    RETURN
    SUMX(Top10,[Enrollment])

    T10P % of TE = [T10P Total]/[Total Students Distinct]

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have solved this, thank you for the input. The two measures needed: 

 

Top10 Program Total =
var A = SUMMARIZE('TE',[program],"Enrollment",SUM('TE'[student_flag])) 

var Top10 = TOPN(10,A,[Enrollment],DESC)
RETURN
SUMX(Top10,[Enrollment])

T10P % of TE = [T10P Total]/[Total Students Distinct]