topic Re: TOP N in DAX Commands and Tips

TOP N

henoktd — Wed, 15 Jan 2025 07:43:07 GMT

wha is the error here.

TopDepartment =

CALCULATE(

FIRSTNONBLANK(KPI[Department], 1),

TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)

Re: TOP N

BeaBF — Wed, 15 Jan 2025 08:14:19 GMT

henoktd Hi! Try with:

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

BBF

Re: TOP N

Anonymous — Thu, 16 Jan 2025 01:16:53 GMT

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

Re: TOP N

Anonymous — Fri, 17 Jan 2025 08:57:00 GMT

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