Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dax table SUMX Distinctcount

Hi!   I got a database log that collect info about my picking rounds.   I´ve tried to create a new table that sums the info about the rounds but my DAX knowledge is unfortunatley not so good.   ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous something like this and you can tweak as per your need:

     

    Table 2 = 
SUMMARIZECOLUMNS(
    Table1[Reg-date].[Date],
    Table1[Round],
    Table1[User],
    Table1[Queue],
    "Nr of codes", 
    COUNT( Table1[Pick-Code] ),
    "Weight",
    SUM(Table1[Weight]),
    "Volume",
    SUM(Table1[Volume] ) 
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous you can create new table using summarizecolumns DAX function

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous something like this and you can tweak as per your need:

 

Table 2 = 
SUMMARIZECOLUMNS(
    Table1[Reg-date].[Date],
    Table1[Round],
    Table1[User],
    Table1[Queue],
    "Nr of codes", 
    COUNT( Table1[Pick-Code] ),
    "Weight",
    SUM(Table1[Weight]),
    "Volume",
    SUM(Table1[Volume] ) 
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You solved it :)

     

    Thanks!