cube don't sum measure in ssas

Question

Good afternoon.
When I filter by dimension “nm sector” brings me the values of each sector, but when I remove this attribute the cube does not perform the sum.
Includes the print of Cube Structure and Dimension Usage
Version Visual studio 2015

Aberto por Setor:

Sumarizado:

Cube Structure:

Dimension Usage:

Answer 1

One important thing you omitted was the measure definition, but, judging by partial substring matches in the names of the objects you did provide, this is just that M2M in action.

Answer 2

brings me the values of each sector

A common cube design failure, there is no relation between cube dimension and the measuregroup defined and so you get for everything the same measure figures.
Open cube design, tab "Dimension Relationships" and define the relation.

Answer 3

Hi @Alberto Oliveira Chaves

You can refer to this link to see how to sum a calculated measure.how-to-sum-a-calculated-measure

Best regards,
Percy Tang

----------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.