Forum Discussion

Ces's avatar
Ces
Frequent Visitor
7 years ago
Solved

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 clie...
Need Help
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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's avatar
Ces
Frequent Visitor
7 years ago
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.