Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Grouping and Full outer join

EVALUATE
ADDCOLUMNS(
VALUES('Inc_$Item Ledger Entry'[Item No_]),

"PurchReq",CALCULATE(SUM(' Inc_$Requisition Line'[Quantity (Base)]))
)

 

I am trying to get the sum  of [Quantity (Base)(integer) grouped by  [Item No which later on have to filter using some status column.

Above query is giving below output 

Item No  PurchReq

1000       4569

1100     4569

1001     4569

L-100   4569

......so on

 

Any suggestion would be of great help. 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous do your tables have a relationship?

    Also, have you tried SUMMARIZECOLUMNS?

    SUMMARIZECOLUMNS(
    'Inc_$Item Ledger Entry'[Item No_],
    "PurchReq",SUM(' Inc_$Requisition Line'[Quantity (Base)])
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      Thank you for your reply.

       

      Yes tables are connected using Item NO column as that is the primary key.

       

      I tried using SUMMARIZECOLUMNS,

       

      Getting below error.

       

      "Multiple columns can not be converted to scalar value"

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous I only seem to get that error when I try to place the formula in a measure by itself. Are you using it in a measure or creating a new table? The formula should work when you use it to create a new table.