Sum values Matrix

[Syndicate_Admin]

Best regards

Create this matrix however the value of the result of total collection hours is not waiting as I can visualize in this table that sum in a correct way? thank you in advance

[v-yueyunzh-msft · Accepted solution]

Hi, @Syndicate_Admin 

It is very common for Total inconsistencies in totals using measures.

You can try to solve this problem using the following method:

You can use the SUMMARIZE() function to create a virtual table to calculate your measures, and then use the SUMX() function to sum up your measures,like this:

Measure = var _t = SUMMARIZE('Table','Table'[Customer], "value", [Total Horas cobro])
return
SUMX(_t,[value])

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

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