Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to reference columns in a summarised table

I have written the following DAX code for a measure   VAR ItemTable = SUMMARIZE(Merge1, Merge1[Item Code], "Occurences", DISTINCTCOUNT(Merge1[Order Id])) VAR Result = SUMX(ItemTable, ItemTable[O...
  • Anonymous's avatar
    Anonymous
    5 years ago

    The (my) problem was more to do with understanding how EVALUATE works. This worked just fine.


     DEFINE

        VAR ItemTable = SUMMARIZE(Merge1, Merge1[Item Code], "Occurences", DISTINCTCOUNT(Merge1[Order Id]))
        
    EVALUATE

        ROW("ResultTable", SUMX(ItemTable, [Occurences]))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Got it, this is what you meant

 

 EVALUATE
(
    VAR ItemTable = SUMMARIZE(Merge1, Merge1[Item Code], "Occurences", DISTINCTCOUNT(Merge1[Order Id]))

    VAR Result = {SUMX(ItemTable, [Occurences])}
    
    RETURN

    Result
)

EVALUATE has to return a table! 🙂

Thanks

 

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

Put the code between curly brackets to return a single scalar value: 

Evaluate

{ code }