Forum Discussion

mroomi's avatar
mroomi
Helper II
9 years ago

Need to create KPI for student

Hi,

I want to create KPI for student enrollment, I have total count of enrooled student. What I want to do is to add a date filter(slider) so depending upon the selection of the year my graph shows todays Vs selected year enrollment data.

In order to achieve (Date slider working with enrollment data) this what do I need to do?

 

Thanks

Roomi 

Tips and Tricks

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    mroomi

     

    I assume you already have the fact data table for that KPI on date granularity. You should add a Year column in your table, then create a calculated measure to have the calculation group on Year level.

     

    Year enrollment =
CALCULATE ( SUM ( Table[enrollment] ), ALLEXCEPT ( Table, Table[Year] ) )

    Regards,