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 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng