Forum Discussion

Robert-bpd's avatar
Robert-bpd
New Member
6 years ago
Solved

Average value not using row count

Hi, I have a table structure like this: Table: Order OrderId Quantity 1 10 2 2   Table: OrderItem OrderId ItemId Value 1 1 15 1 2 6 2 1 12   Table: Item ...
  • az38's avatar
    az38
    6 years ago

    Robert-bpd 

    as I could imagine you need smth like

    Column = DIVIDE(calculate(SUMX('Table (2)', 'Table (2)'[Value]*RELATED('Table'[Quantity]))), calculate(SUMX('Table (2)', 'Table (2)'[Value])))

    but you need check columns depending on your business logic

az38's avatar
az38
Community Champion
6 years ago

Robert-bpd 

as I could imagine you need smth like

Column = DIVIDE(calculate(SUMX('Table (2)', 'Table (2)'[Value]*RELATED('Table'[Quantity]))), calculate(SUMX('Table (2)', 'Table (2)'[Value])))

but you need check columns depending on your business logic