Forum Discussion

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
8 years ago
Solved

Sum by group

Hello Community,    I have a question about sum and group by.  I have read some post but solution dont works with my exemple.    I have a table with this datas User Manager Real Working ho...
Need Help
  • Milozebre's avatar
    Milozebre
    8 years ago

    TomMartensTom.

     

    I have already this measure :) but its not what i want.

    I found another solution with filter and Username.

     

    Thank you for the reference also. 

     

    Have a nice day. 

     

    Dimitri

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

Hey,

 

understand ...

 

So, basically it's always a good idea to create a measure instead of a calculated column, the advantages are

  • smaller memory footprint (this becomes more apparent with larger datasets)
  • interact with selection made by the user (e.g. slicer)

there is one disadvantage of a measure

  • it can't be used as a slicer

Here is a simple example for a measure that counts the user

 

User cnt = 
DISTINCTCOUNT(
    'Table1'[User]
)

If you want to start learning DAX my current recommendation is the book "Beginning DAX" by Phil_Seamark

 

 

Maybe this gets you started.

 

Regards,

Tom

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
8 years ago

TomMartensTom.

 

I have already this measure :) but its not what i want.

I found another solution with filter and Username.

 

Thank you for the reference also. 

 

Have a nice day. 

 

Dimitri