Forum Discussion

russm's avatar
russm
Helper I
10 years ago
Solved

Calculating modes

What is the best way to calculate the mode (central tendency measure) from an unpivoted column of numerical data (e.g., Likert response values) in Power BI?   Thanks,   Russ
  • Anonymous's avatar
    Anonymous
    10 years ago

    russm perhaps the solution offered on this article.

     

    Mode :=
MINX (
    TOPN (
        1,
        ADDCOLUMNS (
            VALUES ( Data[Value] ),
            "Frequency", CALCULATE ( COUNT ( Data[Value] ) )
        ),
        [Frequency],
        0
    ),
    Data[Value]
)
Anonymous's avatar
Anonymous
Not applicable
10 years ago

russm perhaps the solution offered on this article.

 

Mode :=
MINX (
    TOPN (
        1,
        ADDCOLUMNS (
            VALUES ( Data[Value] ),
            "Frequency", CALCULATE ( COUNT ( Data[Value] ) )
        ),
        [Frequency],
        0
    ),
    Data[Value]
)
russm's avatar
russm
Helper I
10 years ago

Perfect!

Thank you!