Forum Discussion

henoktd's avatar
henoktd
Regular Visitor
1 year ago
Solved

TOP N

wha is the error here. 

TopDepartment =
CALCULATE(
    FIRSTNONBLANK(KPI[Department], 1),
    TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)
  • BeaBF's avatar
    BeaBF
    1 year ago

    henoktd Hi! Try with:

     

    TopDepartment =
    CALCULATE(
    SELECTEDVALUE(KPI[Department]),
    TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)
    )

     

    BBF

3 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    1 year ago

    henoktd Hi! Try with:

     

    TopDepartment =
    CALCULATE(
    SELECTEDVALUE(KPI[Department]),
    TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)
    )

     

    BBF

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    HI henoktd,

    Any update on this? Can you please share some more detail information about this issue? They should help us clarify your scenario and test coding formula.

    Regards,

    Xiaoxin Sheng