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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It worked

     

    Thank you very much

  • christinek's avatar
    christinek
    Frequent Visitor
    3 years ago

    Hi KHorseman, I am new to the Power BI Community forum and not sure if this is correct etiquette or not to reply to this post. Please let me know if not. I found this post in my search to calculate 'Mode'. But when I use the solution, I get an error "Function ADDCOLUMNS expects a column name as argument number 4."

    Are you able to shed any light on where I have gone wrong please?