Forum Discussion
Anonymous
7 years agoNot applicable
DAX: TOPN Function Error
Hi all! A beginner here and I would appreciate the help :) I need help in creating a measure in DAX and I don't know if my execution is correct. The thing that I would like to happen is to produce a g...
ryan_mayu
7 years agoSuper User
Anonymous
If you don't want to do the settings in the visualization. I think you need to create a new table.
Table= TOPN( 5, FILTER(Final, Final[Status]="In-Progress"), Final[Assignee],ASC)
I am not sure if this coding can work. You can have a try.
Thanks
Anonymous
7 years agoNot applicable
Hi Ryan!
The code still doesn't work. It has an error that says, "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."