Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Column calculating Totals OR Create a New Table using Groupby function

Hey guys, I'm still struggling with DAX commands but thanks to you guys I'm learning a lot and learning it fast too! I've got a list with all the e-mail interactions per customer in i...
calculated column
groupby
Table
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Anonymous 

     

    NEW TABLE = 
ADDCOLUMNS (
    VALUES('Table'[mailing_id]),
    "Total Opens",
        CALCULATE (
            COUNTROWS ( 'Table' ),
            'Table'[interaction_type] = "OPEN"
        )
)

     


    In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 

 

NEW TABLE = 
ADDCOLUMNS (
    VALUES('Table'[mailing_id]),
    "Total Opens",
        CALCULATE (
            COUNTROWS ( 'Table' ),
            'Table'[interaction_type] = "OPEN"
        )
)

 


In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂