Summarize data into new table

Hi harpreetsingh08 ,

Here a solution in DAX:

Note, I called the table you pasted above 'TableToBeGrouped'

TableGroupedNew = 
SUMMARIZE (
    FILTER ( 
        'TableToBeGrouped', 
        [Ticket Status] = "Open" && CONTAINSSTRING ( TableToBeGrouped[Attributes], "Laptop" )
    ),
    [Department],
    "SumOfTickets", SUM ( 'TableToBeGrouped'[No of device] )
)

Let me know if this helps or if you need the solution in Power Query 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Hi harpreetsingh08 

Awesome that I could help! Do not forget to mark the answer as a solution 🙂

You cannot sum over strings. You need to change the column to number:

Hope this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/