cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ces Frequent Visitor
Frequent Visitor

Filter by response rating scale

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.
 
Question.PNG

Thank you in advance
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter by response rating scale

Hi Ces,

 

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

Capture.PNG 

 

After merged, the new table is like below:

2.PNG 

 

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])))

3.PNG 

 

Regards,

Jimmy Tao

2 REPLIES 2
Community Support Team
Community Support Team

Re: Filter by response rating scale

Hi Ces,

 

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

Capture.PNG 

 

After merged, the new table is like below:

2.PNG 

 

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])))

3.PNG 

 

Regards,

Jimmy Tao

Ces Frequent Visitor
Frequent Visitor

Re: Filter by response rating scale

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.