Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 f...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

    New Table = 
    SUMMARIZE(
      FILTER('Table',[Product Type] = "Bike"),
      [Name],
      "Amount",SUM('Table'[Amount])
    )
amitchandak's avatar
amitchandak
Super User
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Very much appreciated Amitchandak. Will try it now.

     

    Thanks