Reply
Ces Frequent Visitor
Frequent Visitor
Posts: 4
Registered: ‎01-05-2017
Accepted Solution

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

Accepted Solutions
Community Support Team
Posts: 1,943
Registered: ‎02-06-2018

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

View solution in original post

Attachment

All Replies
Community Support Team
Posts: 1,943
Registered: ‎02-06-2018

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

Attachment
Highlighted
Ces Frequent Visitor
Frequent Visitor
Posts: 4
Registered: ‎01-05-2017

Re: Filter by response rating scale

[ Edited ]
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.