Transpose row values to one row value whit delimiter

[Saaam]

Hi!

I have a table "Warehouse" where i can have multiple lines for each item, with different location (WMSLOCATIONID)

Company	ItemId	InventSiteId	InventLocationId	Inventario_Fisico	WMSLOCATIONID
bita	50710100196385	CN	CN01	100	2AM3Y
bita	50710100196385	CN	CN01	90	2EST-G3Z
bita	50710100196385	CN	CN01	25	XEF7X

I need a measure (because i need to apply some filter in) to show all locations for each item row by row, like this:

Company	ItemId	InventSiteId	InventLocationId	WMSLOCATIONID
bita	50710100196385	CN	CN01	2AM3Y / 2EST-G3Z / XEF7X

Actually i did something like this (ignore FILTER):

Ubicazioni = CALCULATE(
                CONCATENATEX(
                    FILTER(WHS_MAGAZZINO_V01,WHS_MAGAZZINO_V01[Inventario_Fisico]>0 &&  
                    NOT (CONTAINSSTRING(WHS_MAGAZZINO_V01[WMSLOCATIONID],"CS_")) && NOT WHS_MAGAZZINO_V01[WMSLOCATIONID] = "PACK" && NOT WHS_MAGAZZINO_V01[WMSLOCATIONID] = "CELLA01" && NOT WHS_MAGAZZINO_V01[WMSLOCATIONID] = "PARKING" && NOT (CONTAINSSTRING(WHS_MAGAZZINO_V01[WMSLOCATIONID],"RECV_"))),
                    WHS_MAGAZZINO_V01[WMSLOCATIONID]," / "),
                    ALLEXCEPT(WHS_MAGAZZINO_V01,WHS_MAGAZZINO_V01[ItemId],WHS_MAGAZZINO_V01[InventLocationId],WHS_MAGAZZINO_V01[itemconfigid])
                )

It works but if i drag up/down the measure in the table it goes from this:

To this:

Like a "big summary" of all locations!

This measure also fail to refresh sometime (memory allocation)

Can you help me to achieve this in a better way?

Thanks!

[amitchandak · Accepted solution]

@Saaam , use isinscope to remove the total value

Assume you have Company in visual at top most level in matrix or used in table visual

a new measure =

If(isinscope(WHS_MAGAZZINO_V01[company]), [Ubicazioni], blank())