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 clients but taking the best answer they have given no matter when they did it.
 

Thank you in advance
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

2 Replies

  • 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.