Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |