Don't summarize values in matrix visual

[dhersz]

Hello,

I've been having a problem that is bugging my mind lately.

So I have this table visual below, where I associate a code with a list of products, their expiration date and some other fields. These are values listed on columns, not measures.

It's working alright, the dates are correct, but since I can have different products within the same code I figured out that using a matrix visual would be better for me.

However, when I use the matrix visualization (and I list code and product name in rows, and the dates in the values) it aggregates my values, which returns the wrong result. Pic below as an example.

For example, the products below ALHO 1123/18 and ALHO 1124/18 have the same name, but have different expiration dates, as it can be seen in the table. When aggregating in matrix it returns the same value.

I feel that the problem is that I'm using a column as a value, not a measure, but I don't know how to write the desired measure. "Writing" my measure in English would be something like "return the date if product code is this and product name is that".

Thanks

[v-yulgu-msft · Accepted solution]

Hi @dhersz,

Fields added to "Values" section of matrix will be aggregated by default. We can change the aggregation function but not able to disable this behavior.

In your scenario, if there existing only one expiration date for each product under the same list code, please try to add below measure:

expiration date = Max('Table'[ExpirationDate])

Best regards,

Yuliana Gu