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] ) ) )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

How does your visual look like?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I want a to display it on a card

  • tamerj1's avatar
    tamerj1
    Community 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?