Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sorting table with multiple columns

Hi All, I need to create a Line and Stacked chart for which multiple columns will be derived using the following conditions: Table name: Survey Steps/Logic: calculate the no. of surveys Group by...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous solution attached, look at table1 in attached, it has few columns and measures. you can play with it as per your need, didn't had much time to work on it thou but I guess you will get idea from it.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello parry2k 

 

Thank you for the reply. No, it won't be aggregated. Aggregation is by Group only.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous  is this expected output?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Exactly!!! Am I missing something? I tried multiple ways but I am in one step behind the solution. Can you please explain?

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous solution attached, look at table1 in attached, it has few columns and measures. you can play with it as per your need, didn't had much time to work on it thou but I guess you will get idea from it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi parry2k 

         

        The below doesn't work and the Y/N column is empty for my case:

        #_TOP = 
var x = TOPN([TOTAL_ROWS], VALUES('Table'[A), [B], DESC) 
RETURN
 IF('Table'[A] IN x, "Y")

        Table is the table name, A, B are the columns. B is the column need to be sorted. Total_Rows is the rows to be taken in Top N.

        Once I get the results, I need to rank the result set by Column C and get only Top 5 Rank. Can you please help on this issue? Thanks!