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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have broadcasting data where each program and each episode has a unique ID. There are however more than one program- and episode name behind each ID. Ideally, I would like to have a Matrix visual where I could expand or collapse a selected program or episode - using the most frequent name as a proxy and saving space by not showing the IDs. The problem with Measures is that they can't be added as rows (which is the prerequisite for expanding/collapsing) - they can only be added under Values:

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

I do not understand.  Someone who does will help you.