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.

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.