GROUP IN DAX

• rashidalen

  Valued Member

  Points: 55

  More actions

  October 21, 2013 at 12:56 am

  #300295

  I'm new to DAX.

  I have table transactions with 2 columns (Salesman, Trans_value). How to sum trans_value for each salesman in DAX?

  www.fcbarcelona.extremazing.com - FC Barcelona - extreme and amazing team

• learnwithvideotutorials

  SSC Veteran

  Points: 251

  More actions

  October 21, 2013 at 1:08 am

  #1660039

  You can use SUMMARIZE:

  EVALUATE

  SUMMARIZE (

  'Transactions',

  'Transactions'[Salesman],

  "Trans. value by Salesman", SUM('Transactions'[Trans_value])

  )

  www.learn-with-video-tutorials.com - video tutorials