Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 use the measure to calculate a "Percent of Students Enrolled in Top 10 Programs" value.
For instance:
1,219 (Sum of Top 10 Program Enrollment Measure) / 2000 (Total Students) = 61%
Thank you in advance!
Solved! Go to Solution.
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]
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]
Hi @Anonymous ,
You could try like this:
Measure 2 =
var total = SUMX(ALLSELECTED('Table'[Program]), [Measure])
return
DIVIDE(total,2000)
@Anonymous This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
@Anonymous , TOPN is one option another option is Rank
example
Top 10 City Rank = CALCULATE([Sales],TOPN(10,all(Geography[City]),[Sales],DESC),VALUES(Geography[City Id]))
For GT
Sum(Table[total student])
or
calculate(Sum(Table[total student]) , allselected(Table))