Forum Discussion

Resolver I

4 years ago

Solved

Create new table that sums rows based on matching column value

I have a table containing data with columns containing a reference (non-unique) and a type (non-unique). A representation is below: TableA Reference Type Value A123 Type1 5521 A123 ...

Need Help

SpartaBI
4 years ago
ddalton create this calculated table:

TableB = ADDCOLUMNS( VALUES('TableA'[Reference]), "Type1", CALCULATE(SUM('TableA'[Value]),'TableA'[Type] = "Type1"), "Type2", CALCULATE(SUM('TableA'[Value]),'TableA'[Type] = "Type2") )

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

SpartaBI Logo

Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI

SpartaBI

Community Champion

4 years ago

ddalton you mean like this? :

TableB = 
ADDCOLUMNS(
    ALL('TableA'[Reference], TableA[Cust]),
    "Type1", CALCULATE(SUM('TableA'[Value]),'TableA'[Type] = "Type1"),
    "Type2", CALCULATE(SUM('TableA'[Value]),'TableA'[Type] = "Type2")
)

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.