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

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