Create calculated table from another table

[Anonymous]

I need to create a table (from the Modelling) based upon the another table to get a filtered result. I have few questions about these calculated DAX tables. 

1. Filtered table or the new table should have 3 columns (Group, no. of reponse, % negative response) - values for only the latest month data from the whole data set

2.  no. of response and % negative response are the Measures in the original table. Is it possible to create table from existing measures?

3. Once the calculated table is created, we need to sort the results and get Top 50% rows from the new table and then Top 5 by sorting the %negative response. 

Thanks!

[v-chuncz-msft]

@Anonymous ,

Yes, just try using TOPN and RANKX.

[Anonymous]

@v-chuncz-msft 

Thanks for the reply.

Yes, I have to use TOP N and Rank for the same.

I have a table T with columns A (grouped by this column) ,B,C

1. I need to use TOP N DAX and get the filered table T with the columns A, B, C which is ordered by Descending with column C. 

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

But this doesn't work and the Y/N column is empty.

2. 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?