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.
I still do not understand your expected result. Someone else who does will help you.
Ashish_Mathur No worries. You did help a lot. Great thanks for that.