Forum Discussion
Search Value on Multiple Columns and return all associated
Hi all, I have a table populated with names in different columns. Each row represents salesperson names who worked together on a specific date. My expected result is a list of names who worked t...
Hi Jorge,
I appreciate your help.
However, I couldn't create the metric SelectedSalesperson once Allsalesperson we created in the first place it's a measure. SELECTEDVALUE has a <column> in its syntax. The same applies to the OtherSalesperson measure where FILTER syntax needs a <table>.
Do you see any alternative to overcome that?
FYI - AllSalespersons, The first dax is for creating the table that your are going to need, is not a dax for a measure, is the dax you use when you create a new table.
then you paste the dax