Forum Discussion
Aggregation on Matrix
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
2 Replies
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
Hi amitchandak
Thanks man, you can download de pbi sample file here
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.
