Total Amount from a Win/Loss Table

[Anonymous]

Hi Everyone,

I have data for Teams in East and West (as seen in atatched image) but unsure on how to make a table like below:

Essentially to look like this: 

Conference	Win	Loss
East	564	176
West	567	199

Thank you for your help! 🙂 

[ChrisMendoza · Accepted solution]

@Anonymous - You could do as:

NewTable = ALLNOBLANKROW(TableName[Conference])

then add new columns like:

W Column = 
SUMMARIZE(
    FILTER(TableName,TableName[Conference] = 'Table'[Conference]),
    "@Sum",SUM(TableName[W])
)

L Column = 
SUMMARIZE(
    FILTER(TableName,TableName[Conference] = 'Table'[Conference]),
    "@Sum",SUM(TableName[L])
)