Forum Discussion

DPozo's avatar
DPozo
New Member
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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]
    )
     
  • DPozo's avatar
    DPozo
    New Member
    2 years ago

    I don't understand your answer.