Summarize with filters

[Anonymous]

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!

[v-yuezhe-msft · Accepted solution]

@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

[affan]

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