Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Grouped SUM

Hello everyone,   I am having trouble to sum a column by ticket ID but the ticket_ID must follow a rule.    Ticket_id Product Product_Type Amount 1 A 0 10 1 B 1 5 1 C 0 10...
condition
Filter
Group By
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Try

    Product	Total Amount =
SUMX (
    VALUES ( Data[Ticket_id] ),
    VAR Check =
        CALCULATE ( COUNTROWS ( CALCULATETABLE ( Data, Data[Product_Type] = 1 ) ) )
    RETURN
        IF ( NOT ISBLANK ( Check ), CALCULATE ( SUM ( Data[Amount] ) ) )
)