How can I compute my "header" array otherwise?

[victormarconis]

I have the measure "demandpresentation" and it returns the right value per line, but when I close the matrix items, it only takes the maximum (I understand that it is because my measure has the MAX), but I wanted that line by line was the MAX and when I closed it, it was the SUM. Even because I have another column "days_of_stock" and then it calculates the stock/demand, and as I'm using the max for the line by line to be correct, it is also incorrect.

demandpresentation = MAX(entradas[demandames])

[Anonymous · Accepted solution]

Hi @victormarconis ,

You can create a new measure that calculates the sum of the maximum values per line when the matrix is closed. First, you need to identify a column that uniquely identifies each row in your data. Let's assume you have a column called . You can create a new measure as follows:

SumOfMaxDemand = SUMX(SUMMARIZE(entradas, entradas[RowID], "MaxDemand", MAX(entradas[demandames])), [MaxDemand])

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.