Merging Row Values in a column

[OsmanEmi]

Hi All,

I have a column with row values I would like to merge however unsure how I should progress with this.

For example in the below table I would like to merge all "Blue Barrels".

Any insights would be greatly appreciated.

The expected output would be for all instances of blue barrels to be merged in relation to store number or store name.
for example
store number 935
blue barrel 120l - 20
blue barrel 240l - 40

I would like it to be summed to display
store number 935
blue barrel - 60

[Tahreem24]

@OsmanEmi ,

Try this DAX measure:

Measure = CALCULATE(SUM(Table[SalesColumn]),FILTER(Table,SEARCH("Blue Barrels",Table[Type],1,0)))

[Pragati11]

Hi @OsmanEmi ,

I don't understand your query completly. What is the expected output?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[OsmanEmi]

I have updated to show expected output on my original message apoligies for not being clear enough.

[Pragati11 · Accepted solution]

Hi @OsmanEmi ,

You can use a matrix visual in Power BI to achieve this:

• Select matrix visual
• Move "Store Name" to ROWS section
• Move "Type" to COLUMNS section
• Move "COUNT(Type)" to VALUES section

As you haven't attached a sample data file, I can't try it at my end, but try the above solution.

Thanks,

Pragati