Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NiallMoo
Regular Visitor

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! 🙂 winloss.PNG

 

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

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

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

1 REPLY 1
ChrisMendoza
Resident Rockstar
Resident Rockstar

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

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.