Forum Discussion
Anonymous
7 years agoNot applicable
Summarize with filters
Hello Everyone
I want to create a sumarized table with certain information given by a specific column, I need the same table but only with the options marked.
But when I do this: SC_PED = SUMMARIZE(FILTER(SD_PEDIDOSBLOQUEOS;SD_PEDIDOSBLOQUEOS[CLASE_DOCUMENTO]="KE");SD_PEDIDOSBLOQUEOS[CLASE_DOCUMENTO])
I can only filter one option and I need 6
If someone knows how to extract the same table but only with the marked options please!
- Anonymous7 years ago
Anonymous,
Please change your DAX to the following:SC_PED = SUMMARIZE(FILTER(SD_PEDIDOSBLOQUEOS;SD_PEDIDOSBLOQUEOS[CLASE_DOCUMENTO]in {"KE";"KB";"ZP01";"ZP02";"ZP07";"ZP08"});SD_PEDIDOSBLOQUEOS[CLASE_DOCUMENTO]).
Regards,
Lydia
2 Replies
- affan
Solution Sage
Hi Anonymous
It seems that the 'Group by' can resolve your issue in the query editor. If you can share the pbix file with me I hope I can share the solution with you
- AnonymousNot applicable
Anonymous,
Please change your DAX to the following:SC_PED = SUMMARIZE(FILTER(SD_PEDIDOSBLOQUEOS;SD_PEDIDOSBLOQUEOS[CLASE_DOCUMENTO]in {"KE";"KB";"ZP01";"ZP02";"ZP07";"ZP08"});SD_PEDIDOSBLOQUEOS[CLASE_DOCUMENTO]).
Regards,
Lydia