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] ) ) )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I want a to display it on a card

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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] ) ) )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    tamerj1 perfect! 

    Is it to much to ask the rational behind your code?