Forum Discussion
Solved
Problems with EARLIER
Hi everyone, I got a table like this: WEEK BELL REJECTED 1 1 1 1 2 1 1 1 2 1 2 3 2 1 25 2 2 26 2 1 4 2 2 2 2 1 0 I would like to mea...
You can use a measure like this - taking the Top 1 descending
Top1 = SUMX(TOPN(1,SUMMARIZE(WeekBellRejected,WeekBellRejected[Bell],"TotalRejected", SUM(WeekBellRejected[Rejected])),[TotalRejected], DESC),[TotalRejected])
You can use a measure like this - taking the Top 1 descending
Top1 = SUMX(
TOPN(
1,
SUMMARIZE(
WeekBellRejected,
WeekBellRejected[Bell],
"TotalRejected", SUM(WeekBellRejected[Rejected])
),
[TotalRejected], DESC
),
[TotalRejected]
)
- It works perfectly! Thanks!
