Forum Discussion

MaxItaly's avatar
MaxItaly
Icon for Helper III rankHelper III
8 years ago
Solved

Help creating a table based on another one (only distinct value)

Hello everyone, I'm having some problems trying to create a table. Let's say I have a table named "Table1", that has "Client", "Quantity". I may have more rows for the same "Client" with different...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi MaxItaly,

     

    You need to create a new table with the following sintax:

     

    Table2 = SUMMARIZE(Table1,Table1[Client],"Quantit"y, SUM(Table1[Quantity]))

     

    You can also duplicate the table on the query editor and choose transform make a group by client and sum the quantity.

     

     

     


    Regards

    MFelix

     

MaxItaly's avatar
MaxItaly
Icon for Helper III rankHelper III
8 years ago

I know it, but way too often the tables are not optimized for Business Intelligence operations   :(

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

No problem, you should use the Query to optimize your data and then use the measures to make your visuals. But this is just a good practice, because duplicating tables will have an impact on your analisys but also on size of files, dependency and overall performance.

 

Regards,

MFelix