Forum Discussion
reynaldo_malave
5 years agoHelper III
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 :...
amitchandak
5 years agoSuper User
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_malave5 years agoHelper III
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.