Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Total Amount from a Win/Loss Table

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: 

ConferenceWinLoss
East 564176
West567199

 

Thank you for your help! 🙂 

 

Need Help
Tips and Tricks
  • ChrisMendoza's avatar
    ChrisMendoza
    3 years ago

    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])
)

1 Reply

  • ChrisMendoza's avatar
    ChrisMendoza
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    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])
)