Aggregation on Matrix

[reynaldo_malave]

Hi Guys,

I am trying to aggregate a measure on a matrix column. This is what it looks like now. But I want it to be aggregated as you go up the matrix

I am using the following measure :

Costo Oportunidad = 

var precio_producto =

    LOOKUPVALUE(
        DM_productos[pvp],
        DM_productos[simi_code],
        SELECTEDVALUE(
            DM_productos[simi_code]
        )
    )

return

IF(
[Brecha]<0,
[Brecha] *-1*precio_producto
)

 Thanks,

Reynaldo

[amitchandak]

@reynaldo_malave ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. And logic what are you trying to achieve here

[reynaldo_malave]

Hi @amitchandak 

Thanks man, you can download de pbi sample file here

 https://farmaciasdesimilares-my.sharepoint.com/:u:/g/personal/inreynaldo_porunpaismejor_com_mx/Ecv0X...

What I am trying to achive is an aggregation on column [Costo de Oportunidad]. Take a look at the image i shared and notice how all columns are aggregated but the last one. First one adds up 57 then the second 50 and the third one 7. I want to be the same with the last one.