Forum Discussion
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...
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 Thanks Ashish, it works fine in my model. Appreciated.
You are welcome. If my previous reply helped, please mark that as Answer.