Forum Discussion

alina_90's avatar
alina_90
Frequent Visitor
8 years ago
Solved

Summarize with conditions

Hi,   what measure let me summarize the "Invoice" values which should be distinct by "Customer number", "Delivery address", "Localisation", "Year", "Month". Any ideas?    Alina    Customer n...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    alina_90

     

    I show you two ways of obtain this:

     

    1. In Query Editor:

     

     

    2, In DAX

     

    Go to Modeling - New Table

     

    Table =
SUMMARIZECOLUMNS (
    Table2[Customer number];
    Table2[Delivery address];
    Table2[Localisation];
    Table2[Year];
    Table2[Month];
    "SUMINVOICES"; SUM ( Table2[Invoice] )
)

    Let me know if works on your side

     

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

alina_90

 

I show you two ways of obtain this:

 

1. In Query Editor:

 

 

2, In DAX

 

Go to Modeling - New Table

 

Table =
SUMMARIZECOLUMNS (
    Table2[Customer number];
    Table2[Delivery address];
    Table2[Localisation];
    Table2[Year];
    Table2[Month];
    "SUMINVOICES"; SUM ( Table2[Invoice] )
)

Let me know if works on your side

 

Regards

 

Victor

Lima - Peru

alina_90's avatar
alina_90
Frequent Visitor
8 years ago

Hi Vvelarde

 

I followed the instruction by DAX because I don't see the new table in query editor. 

Everything workes fine, thanks a lot for your help! :) 

 

Best regards,

 

Alina - Poland