Matrix Table Summarize Field

[tanyatessteam]

I am adding a qty field into my matrix table and it continues to summarize the field or count the field.

I have changed all the settings to not summarize and I have changed it to a decimal, whole number, text and it is still not having any effect.

These are my only options and from the screenshot above.

[Anonymous]

Hi    @tanyatessteam ,

Do your fields in the matrix come from the same table.

If not, is there a relationship between the table and the table.

can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data

Best Regards,

Liu Yang

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

[tanyatessteam]

I am not sure I understand what you mean are you saying that if I use a matrix table I am required to have an aggregation?

[amitchandak]

@tanyatessteam , if you give anything in the values it needs to have some aggregation in the case of Matrix. That can not be un summarized in values