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:  Conference Win Loss East  ...
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])
)

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