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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Combining Summarize and Lookupvalue

Hi,

 

Im struggling with the following, any help is much appreciated. I have a table called "Product" with information and a newly created Table called "Information" where some of the information from table "Product" needs to be placed.

 

Table Product

NameProduct TypeAmount
RedBike2
BluePlane5
BlackBoat7
RedTree1
BlackTable4
PurpleBike10
PurplePlane2
RedBike4
PurpleBike1

 

The data that i want to store in the newly created table called "Information" is the name and amount where the product type is Bike

 

(New) Table Information

NameAmount
Red6
Purple11

 

Thank you very much for your help.

 

Peter

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Perhaps:

 

New Table = 
    SUMMARIZE(
      FILTER('Table',[Product Type] = "Bike"),
      [Name],
      "Amount",SUM('Table'[Amount])
    )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

Perhaps:

 

New Table = 
    SUMMARIZE(
      FILTER('Table',[Product Type] = "Bike"),
      [Name],
      "Amount",SUM('Table'[Amount])
    )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@Anonymous , Try like

summarize(filter(Table,Table[Product Type]="Bike"),table[Name], "Amount", sum(Table[Amount]))

If you put a Slicer of Product Type and filter Bike and use any visual with Name and sum of Amount. you should get this

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Very much appreciated Amitchandak. Will try it now.

 

Thanks 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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