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

 

Hi, do you want a New table with unique rows based in that columns?

 

Or a Count of Rows based in that columns?

 

Regards

 

Victor

 

alina_90's avatar
alina_90
Frequent Visitor
8 years ago

Hi,

 

Vvelarde whatever works :) 

 

Alina

  • 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