Hola a todos,
Tengo una consulta DAX que usa Summerizecolumns con order by.
y la consulta es la siguiente.
EVALUATE
SUMMARIZECOLUMNS(
Projects[Top_ProjectManager],
KEEPFILTERS( FILTER( ALL( Projects[Top_ProjectManager] ), NOT( ISBLANK( Projects[Top_ProjectManager] ))))
)
ORDER BY
Projects[Top_ProjectManager] ASC
los datos que recupera como
| Top_ProjectManager |
| Abdullah, Qassim |
| Acree, Adán |
| Adán Knier |
| Adkins, Chad |
| Akbay, Volcán |
| Akers, Pablo |
| Ali Keyvani |
| Ambariantz, Zacarías |
| Andrew Eck |
| Andrew Jason Dobrozsi |
| Ankur Rathor |
| Antonios, Walid |
| Argo, Cristóbal |
| Arnold, Juan |
| Avellano, Michael |
| Baer, Juan |
| Banovic, Kevin |
| Barker, Kristine |
| Barnhill, Guillermo |
| Bates, Brian |
| Batallas, Michael |
| Baxter, Pablo |
| Beale, Judy |
| Behrens, Brian |
| Behrmann, Michelle |
| Benjamín Keith Liptak |
| Bennett, Richard |
| Bissaillon, José |
| Hoja Alexander Hauth |
| Blaskovich, Megan |
| Bobko, Sam |
| Boltz, Jay |
| Borowiec, Jeffrey |
| Bradshaw, Dianne |
| Brett Harmon |
| Breunig, Denise |
| Marrón, Curtis |
| Brown, Douglas |
| Bryan Albert De Jesús |
| Bryan Scot Gregory |
| Burkey, Jacob |
| Mayordomo, Ryan |
| Carl F. Armanini |
| Carol Anne Lockhart |
| Cestnick, Juan |
| Christina Lynn Martínez |
| Cristóbal Raml |
| Chu, Fred |
| Chu, Ted |
| Clarkson, Harold |
| Cocanougher, Juan |
| Cole, Eric |
| Coles, Melissa |
| Conner, Mendi |
| Copeland, Eduardo |
| Tripulaciones, Ellen |
| Crystal Childress |
| Culbert, Cristina |
| Dabney, Unwanna |
| Damjanovic, Dejan |
| Daniel Andrés Rey |
| Daniel J Kuester |
| David A. Feuer |
| David A. Barron |
| David M. Dillow |
| David M Helter |
| David N Ayala |
| David S. Rickard |
| Davis, George |
| El oso, Lueann |
| De la Cruz, Isaac |
| Denny, Gary |
| Devisser, Caso |
| Diane Schlemmer |
| DiPilla, Pedro |
| Dobrozsi, Santiago |
| Dominic Vivian Hilton Thomas |
| Donna Pauline Taylor |
| Doug Garvey |
| Douglas S Richter |
| Douglas, Amanda |
| Downey, Jonathan |
| Drew W Linck |
| Dudley Smith |
| Dushan Arumugam |
| Dyer, Gregorio |
| Einspahr, Morgan |
| Elam, Preston |
| Anciano, Jill |
| Eli Donaldson |
| Eric Adam Jesse |
| Erickson, Jesse |
| Esfahani, Marjan |
| Esmaeili, Nasim |
| Etherington, Andrés |
| Flor, Pablo |
| Fischer, Carla |
| Fischer, Nathan |
| Fletcher, Hilary |
| Fluhr, Marisa |
| Ford, Michael |
| Foster, Brian |
| Zorro, Gregorio |
| Frank Monastra |
| Frank Simpson Orr |
| Fritsche, Barb |
| García, Brezo |
| Gary Edward Murray |
| Gauron, Trevor |
| Geboy, Jill Mackenzie |
| Gerdeman, Richard |
| Gerhard, Juan |
| Giessing, Chris |
| Gilbreath, Mateo |
| Gillespie, Mateo |
| Godfrey, Steven |
| Goldberg, Lawrence |
| Golombek, Yaneev |
| Gonzales, Benito |
| Goodell, Jessica#Jessica |
| Buenas noches, Craig |
| Gotschall, David |
| Gregorio D Harnish |
| Griesel, Dirk |
| Grohol, Morgan |
| Gromak, Natasha |
| Gross, Amanda |
| Gwin, Thomas |
| Hale, Timoteo |
| Hall, David |
| Hamilton, Ean |
| Hamilton, Eric |
| Hammond, Benjamín |
| Hanowsky, Miguel |
| Harding, Michael |
| Hartley, Chad |
| Heid, Josué |
| Hensley, Darío |
| Herndon, Emily |
| Heydenrych, Riaan |
| Hocker, Benjamín |
| Hogan, Jeffery |
| Holbrook, K. |
| Holder, Guillermo |
| Hopper, Nathan |
| Abrazo, Justin |
| Hughes, Scott |
| Humphrey, Marcos |
| Caza, Cody |
| Hurst, danés |
| Hutchinson, Mateo |
| Ingram, Juan |
| Isenberg, Nicolás |
| J. Todd Henwood |
| Jaeger, Chris |
| James A. Goggan |
| James P. Kendall |
| Jason Adam Golub |
| Jeffrey Pierce |
| Jennifer Davis |
| Jeremy Stewart |
| Jesse Blackstock |
| John B Tye |
| John E. Schooler |
| John M. Alberti |
| John Matthew Fuller |
| John R. Nierzwicki |
| Johns, Jason |
| Johnson, Derek |
| Johnson, Mateo |
| Jonathan L Grzywa |
| Jonathan R. Sheidler |
| José Antonio Margio |
| José M Muere |
| Kaderka, Darrell |
| Kail, Jason |
| Peleas, Sean |
| Katie R. Thayer |
| Keagy, Richard |
| Kelly, Margarita |
| Parque Kent |
| Kevin K Shirer |
| Rey, Mateo |
| Kirsten Tynch |
| Knolle, Rebecca |
| Kohlbacher, Kathryn |
| Koonce, Laura |
| Kouns, Jennifer |
| Kowalkowski, Nicolás |
| Kreger, Esteban |
| Kurtz, Seth |
| Kuxhausen, Daniel |
| Kuxhausen, David |
| Leary, Timoteo |
| Leitch, Roberto |
| Lesko, Ian |
| Menos, Thomas |
| Lickert, María |
| Little, Wilbur |
| Loker, Megan |
| Long, Michael |
| Lovato, Marcos |
| Lucas, Adán |
| Ludwig, Cristóbal |
| Luiz Frediani |
| Maas, Daniel |
| MacDonald, Eric |
| Mackie, Thomas |
| Manderson, Kyle |
| Mark Aaron Mockus |
| Marcos Guthrel |
| Martín, Juan |
| Iglesias de Mateo |
| Matthew James Harrison |
| Mattox, Ronald |
| Mcclurkin, José |
| Mccroskey, Ryan |
| McDaniel, Kirt |
| McDonald, Scott |
| McElfresh, Maureen |
| McGovern, Michael |
| McKoy, Jenine |
| Meade, Melissa |
| Meggyesy, Danielle |
| Meiser, Michael |
| Mel C Leseberg |
| Melanie Chavarría |
| Menezes, Sheldon |
| Mercancía, Thomas |
| Michael Dennis Tegethoff |
| Michael John Zoltek |
| Michael Kirk Maynard |
| Michalec, Daniel |
| Michelle Lee Carroll |
| Miklas, James |
| Mil millones, Michelle |
| Millinor, Guillermo |
| Mochty, Thomas |
| Moffat, Samuel |
| Mohiuddin, Golam |
| Monnig, Juan |
| Montgomery, Jason |
| Moore, Shawn |
| Morgan, Jeffrey |
| Morgan, Timoteo |
| Mosaffa, Emir |
| Muller, Cristal |
| Muscarella, Carla |
| Naicker, Kamashnee |
| Naicker, Kirsty |
| Ness, Justin |
| Nielsen, Kirk |
| Nix, Ray |
| Noble, Jonathan |
| Nodich, Alex |
| Ortiz, Sandra |
| Overton, James |
| Paquete, Andrés |
| Paden, Bret |
| Parr, Cristina |
| Pathakamuri, Bhargavi |
| Paul Strack |
| Perry, Cristóbal |
| Perry, Lauren |
| Pesler, Jeffery |
| Pestka, Joe |
| Phillips, María |
| Pickford, Andrés |
| Pieterse, Jacques |
| Pillay, Nivara |
| Pisana, Arturo |
| Plews, Patrick |
| R. Scott Schmidt |
| Rango, Melissa |
| Raymond, Benjamín |
| Reber, Tim |
| Remstad, Andrés |
| Rhoades, Timoteo |
| Richard y Harrison |
| Acertijo, James |
| Risner, Eric |
| Robert F. Brinkman |
| Robert K Veech |
| Robert Scott Sanders |
| Rousseau, Booye#Booye |
| Roy José Interrante |
| Ryan Alan Robinson |
| Sabourin, Julie |
| Sadeghi, Sam |
| Salazar, Tracey |
| Salinas, Julio |
| Sanfiel, José |
| Scherr, Kevin |
| Schneider, Cody |
| Schreuder, Ethan |
| Seamster, Emily |
| Yo, Kenneth |
| Seppi, José |
| Shamonsky, Karen |
| Sharma, Prateek |
| Sherilyn R Kosmos |
| Shillington, Marcos |
| Shivprakash Iyer |
| Corto, Anne |
| Shrestha, Prakash |
| Shuman, Zachary |
| Shuttleworth, Gregorio |
| Siney, Ronald |
| Cantante, Edward |
| Smallwood, Brian |
| Smith, Bryan |
| Smith, Pablo |
| Smits, Marcos |
| Snyder, Cristóbal |
| Solemani, Constanza |
| Spinks, Melvin |
| Sprague, Jessica |
| Stedman, Kelly |
| Steele, Walter |
| Stelios M Xystros |
| Stephen D Tolison |
| Steven L Nixon |
| Steven W. Schwabe |
| Steven Ward McCollum |
| Stevens, Brian |
| Strelitz, Emily |
| Tabb, Danielle |
| Thomas Ruschkewicz |
| Tilly Pillay |
| Timko, Michael |
| Todd Duwel |
| Todd M Andrews |
| Tolison, James |
| Caída, David |
| Tomczyk, Marcos |
| Tongay, Guillermo |
| Townley, Jennifer |
| Travis Ryan Davis |
| Tyler Bicknell |
| Undercoffer, Jason |
| Vallin, Travis |
| Vanderwalt, Barry |
| Vaughn, Roy |
| Virzi, Jason |
| Voisard, Roberto |
| Walker, Guillermo |
| Muro, David |
| Walter, Ryan |
| Washington, Richard |
| Semanas, Jon |
| Wehmeyer, André |
| Welling, David |
| Wess, Ley |
| Wiley, Jonathan |
| Wilhelmi, Nathan |
| Guillermo Gunkle |
| Guillermo Howard Sukenik |
| Guillermo Powell |
| Guillermo Speck |
| William W. Schwegler |
| Williams, Anthony |
| Williams, Daisylyn |
| Williams, Kelly |
| Wilson, Michael |
| Wilson, Nathan |
| Wimberley, Cristóbal |
| Lobo, Samuel |
| Digno, Steven#Matt |
| Yates, Scott |
| Zachary Valchar |
| Zarlengo, Michael |
| Ziegman, David |
| Zumwald, José |
Ahora me gustaría agregar un valor como NA a la columna y hacer la unión de la consulta anterior y el nuevo valor.
Así que he escrito debajo de DAX.
EVALUATE
UNION
(
DISTINCT(SELECTCOLUMNS(Projects,"Top_ProjectManager","NA"))
,
SUMMARIZECOLUMNS(
Projects[Top_ProjectManager],
KEEPFILTERS( FILTER( ALL( Projects[Top_ProjectManager] ), NOT( ISBLANK( Projects[Top_ProjectManager] ))))
)
//ORDER BY
//Projects[Top_ProjectManager] ASC
)
Con esto puedo agregar NA como nueva fila vlaue pero lo que estoy perdiendo es el orden de la consulta summerizecolumns en ella.
Por lo tanto, el resultado final debe ser, NA debe ser superior, luego seguido por el Orden por en top_projectmanager es orden asc.
¿Alguien puede ayudarme en esto?
Gracias
Mohan c.
