Total Error Matrix

[Syndicate_Admin]

Hello

I have a matrix that shows data coming from several related tables:

NOTICES table: contains the data and is related to the PRODUCTS table

PRODUCTS table: By means of an intermediate table RELATIONSHIPS is related to the SERVICES table

The matrix is defined:

Rows:

• Scope (SERVICE table)
• Service (SERVICE table)
• Product (PRODUCT table)

Columns:

• Severity (NOTICES table)

Values:

• ticket count (NOTICES table)

even the subtotals of the "Service" row are calculated correctly, but the endings of Scope are incorrect. I've tried several options but nothing seems to work... Any ideas?

[Anonymous · Accepted solution]

Hi @Syndicate_Admin 

Create a measure first to calculate ticket count to replace the value, you can call it [Count] measure.

Then create a new measure.

Measure =
SUMX ( VALUES ( 'SERVICE'[Service] ), [Count] )

Put the measure to the value field in the matrix.

Best Regards!

Yolo Zhu

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

[Syndicate_Admin]

Hello! It worked perfectly, thank you so much!