Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    2

    Unanswered: Group and SUM in DAX

    I'm new in Analysis Services tabular model.
    I have table transactions with columns:
    - Salesman,
    - Trans_value).
    How to group and sum trans_calue for each salesman in DAX?
    Last edited by gvee; 10-21-13 at 04:57. Reason: links neutered

  2. #2
    Join Date
    Oct 2013
    Location
    Poland / USA
    Posts
    5

    Summarize

    use EVALUATE and SUMMARIZE:

    EVALUATE
    SUMMARIZE (
    'Transactions',
    'Transactions'[Salesman],
    "Trans. value by Salesman", SUM('Transactions'[Trans_value])
    )
    Last edited by gvee; 10-21-13 at 04:57. Reason: links neutered

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •