Forum Discussion

ngct1112's avatar
ngct1112
Post Patron
5 years ago
Solved

DAX - Most Frequent value

Hi,   I would like to find the most frequenct value(most repeated times) by DAX. May I know is it possible?   Original Table Item ID user 1 1 Peter 1 2 Peter 1 3 Alex 1 4...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    To your Table visual, drag the Item field and write these mesures

    User count = counta(Data[User])

    Most frequency = FIRSTNONBLANK(TOPN(1,VALUES(Data[User]),[User count]),1)

    Drag the second measure to your visual.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

To your Table visual, drag the Item field and write these mesures

User count = counta(Data[User])

Most frequency = FIRSTNONBLANK(TOPN(1,VALUES(Data[User]),[User count]),1)

Drag the second measure to your visual.

Khaled2023's avatar
Khaled2023
Frequent Visitor
2 years ago

Hi,

 

How can I get the number (how many times repeated the most frequent value).

I'd like to display it in a card.

 

Thanks

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Write the formula suggested in my message.  If t does not work, then share some data to work with, explain the question and show the expected result.

    • Khaled2023's avatar
      Khaled2023
      Frequent Visitor
      2 years ago

      Hi, apprecaite your feedback. 

      It works and give me the value "Name of most frequent client", but I need how many time this client name repeated, for example 10 times. I need it as measure not column nor table.

       

      Thanks

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        Hi,

        Drag client to the visual and write this measure

        Count = countrows(Data)

        Hope this helps.