Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Unique Projection Calculation

Hello   I am trying to build a calculation that will project our expected enrollment based on our ROE metric.  My company deals with interntional student enrollments and we use a Rate of Enrollment...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

To create a measure as below.

 

Measure = 
VAR roelast =
    CALCULATE (
        SUM ( 'Data for ROE Projections'[ROE] ),
        FILTER (
            ALL ( 'Data for ROE Projections' ),
            'Data for ROE Projections'[Year]
                = CALCULATE (
                    MAX ( 'Data for ROE Projections'[Year] ),
                    ALL ( 'Data for ROE Projections' )
                )
                    - 1
                && 'Data for ROE Projections'[Semester] = "Fall"
        ),
        VALUES ( 'Data for ROE Projections'[Country] )
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Data for ROE Projections'[Year] )
            = CALCULATE (
                MAX ( 'Data for ROE Projections'[Year] ),
                ALL ( 'Data for ROE Projections' )
            )
            && SELECTEDVALUE ( 'Data for ROE Projections'[Semester] ) = "Spring",
        roelast,
        BLANK ()
    )

Also please find the pbix as attached.

 

Regards,

Frank