Sustainable Development Goals - TARGET 4.A : Build and upgrade inclusive and safe schools - Power BI

The Sustainable Development Goal Dashboard is my capstone project in my Microsoft Power BI Masterclass. Each student is assigned to pick one goal out of 17 to make a useful report that will help solve the problem. The dashboard displays a visual of quality education in each country.

Dashboard Link: https://app.powerbi.com/view?r=eyJrIjoiZGEyODg2NmYtZTY4Ni00ZTA4LTllMmItMzc5N2E3NDczMWMxIiwidCI6ImFmOTE2MGUxLWU1NDUtNDdkOS1hNzQ0LTM3YmZlNzEyNDIwYSIsImMiOjEwfQ%3D%3D

Measures I used

Primary_Latest_Value =     
     VAR _LatestYear = (Fact_Table[Year])    
     VAR _Result = CALCULATE([-Entity Value], Fact_Table[Year] = _LatestYear, Dim_School_Rank[School Rank No.] = 0)

     RETURN       
          IF(
               _Result = 0,
               "0", 
               _Result)

Upper_Secondary_Latest_Value =      
     VAR _LatestYear = MAX(Fact_Table[Year])         
     VAR _Result = CALCULATE([-Entity Value], Fact_Table[Year] = _LatestYear, Dim_School_Rank[School Rank No.] = 2)     

     RETURN                     IF(
               _Result = 0, 
               "0", 
               _Result)

Entity Value = 
     Average(
          Fact_Table[Value]
          )

World Average = 
     CALCULATE(
          AVERAGE(Fact_Table[Value]), 
          ALL(Dim_Flag[Entity])
          )

Average = 
     AVERAGE(
          Fact_Table[Value]
          )

Lower Secondary Value =     
     CALCULATE(        
          AVERAGE(Fact_Table[Value]),        
          Dim_School_Rank[School Rank %] = "Lower Secondary"
          )

Primary Value =     
     CALCULATE(        
          AVERAGE(Fact_Table[Value]),        
          Dim_School_Rank[School Rank %] = "Primary"    
          )

Upper Secondary Value =     
     CALCULATE(        
          AVERAGE(Fact_Table[Value]),        
          Dim_School_Rank[School Rank %] = "Upper Secondary"    
          )

Rank =
     VAR _Desc = RANKX(ALL(Fact_Table[Entity]), [Entity Value], , DESC, Dense)    
     VAR _Asc = RANKX(ALL(Fact_Table[Entity]), [Entity Value], , ASC, Dense)    
     VAR _Condition = IF(SELECTEDVALUE(ZFilter[Filter No]) = 0, _Desc, _Asc)

     RETURN       
          _Condition

%Entity =     
     DIVIDE(
          [Entity Value]-[World Average],
          [World Average],
          0
          )

LS Bar Formatting =     
     VAR _EntityValue = [Entity Value]    
     VAR _WorldAverage = [World Average]    
     VAR _Result =     
          SWITCH(        
          TRUE(),        
          _EntityValue>_WorldAverage,        
          "#E09F3E",        
          "#B3B3B3"
          )

     RETURN        
          _Result

Primary Bar Formatting =     
     VAR _EntityValue = [Entity Value]    
     VAR _WorldAverage = [World Average]    
     VAR _Result =     
          SWITCH(        
          TRUE(),        
          _EntityValue>_WorldAverage,        
          "#9E2A2B",        
          "#B3B3B3"
          )

     RETURN        
          _Result

US Bar Formatting =     
     VAR _EntityValue = [Entity Value]    
     VAR _WorldAverage = [World Average]    
     VAR _Result =     
          SWITCH(        
          TRUE(),        
          _EntityValue>_WorldAverage,        
          "#335C67",        
          "#B3B3B3"
          )

     RETURN        
          _Result

Year = 
     YEAR(
          Dim_Calendar[Date]
     )

Year Number = 
     FORMAT(
          Dim_Calendar[Date], "YY"
     )