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, 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.