henoktdRegular Visitor1 year agoSolvedTOP N wha is the error here. TopDepartment = CALCULATE( FIRSTNONBLANK(KPI[Department], 1), TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC) Show MoreBeaBF1 year agohenoktd Hi! Try with: TopDepartment =CALCULATE(SELECTEDVALUE(KPI[Department]),TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)) BBF
BeaBF1 year agohenoktd Hi! Try with: TopDepartment =CALCULATE(SELECTEDVALUE(KPI[Department]),TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)) BBF
BeaBF1 year agohenoktd Hi! Try with: TopDepartment =CALCULATE(SELECTEDVALUE(KPI[Department]),TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)) BBF
BeaBFSuper User1 year agohenoktd Hi! Try with: TopDepartment =CALCULATE(SELECTEDVALUE(KPI[Department]),TOPN(1, ALL('KPI'), [DepartmentAchievement], DESC)) BBF
Related contentTOP NTop 5 in descending orderTOP NKudos and the Top Kudoed Authors widgetFreeze top header
