cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhersz
Frequent Visitor

Don't summarize values in matrix visual

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.

 

image.png

 

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.

 

image.png

 

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

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yulgu-msft
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.