Forum Discussion

panatb's avatar
panatb
Regular Visitor
2 years ago
Solved

Summarize with Sumx

Hi, I am a new to Dax and struggling to achieve the below. Appreciate any help and advice: I have a table with duplicates. I want to create a virtual table with Summarize with Sumx function as below...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    panatb Use this instead:

    Virtual_Table = 
  ADDCOLUMNS(
    SELECTCOLUMNS( SALES_TABLE, "ITEM", [ITEM] ),
    "SALES_AMT", [UNIT PRICE] * [QTY]
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

panatb Use this instead:

Virtual_Table = 
  ADDCOLUMNS(
    SELECTCOLUMNS( SALES_TABLE, "ITEM", [ITEM] ),
    "SALES_AMT", [UNIT PRICE] * [QTY]
  )