Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!

  • Anonymous's avatar
    Anonymous
    7 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's avatar
    affan
    Icon for Solution Sage rankSolution 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

  • Anonymous's avatar
    Anonymous
    Not 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