Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create calculated table from another table

  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 sh...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?