Filter by response rating scale

[Ces]

Hello, I need your help

I have this table that registers a list of clients and their answer to a valuation question asked at different times, what I need is to get a table filtered by unique clients but taking the best answer they have given no matter when they did it.

Thank you in advance

[v-yuta-msft · Accepted solution]

Hi Ces,

To achieve your requirement, click query editor-> Merge Queries.

 

After merged, the new table is like below:

 

After close&applied, create a measure using DAX below:

Best Answer = CALCULATE(MAX(Merge1[Answer]), FILTER(ALLEXCEPT(Merge1, Merge1[Name]), Merge1[Value] = MAX(Merge1[Value])))

 

Regards,

Jimmy Tao

[Ces]

Thank you very much Jimmy

Works perfectly as intended, but, sorry to bother you a little bit more.

in the solution obtained how it would be possible to count the number of customers who responded "Very Good", "Good", "Regular", etc.