topic Re: How can I compute my "header" array otherwise? in DAX Commands and Tips

How can I compute my "header" array otherwise?

victormarconis — Tue, 25 Jul 2023 17:01:56 GMT

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])

Re: How can I compute my "header" array otherwise?

Anonymous — Thu, 27 Jul 2023 01:36:43 GMT

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.