Avoid sum multiple times same value on column

I guess with "view" you mean a table or matrix visual, right? assuming that you could just use the amount column from the Batch table and make sure it is not using it as an implicit measure, so:

Hi,

You need to put the amount column in the row and failures in the value of a matrix visual. you may use date as slicer or in the row above amount in the matrix visual as well.

Thank you so much for the quickly answers, they made me think and prepare and simple example that helps to find the solution: 

When I am talking about a view, I mean a database view (data from multiple tables together) and that's here where I made a mistake

My model was like that: 

That's the data

So, when I go level down in the grid the behaviour was like this: 

As you can see, power bi is multipling the batch amount by the number of registers so the total amout is wrong. 

But, as I said before, to show you a simple model I create this one: 

It works well cause Power BI knows the amout of batch is not a part of the registers. 

Now I have to find how to make it work without both direction relation between Revision and Batch. I read that is not recommended 

Sorry for make you waste your time and thank you so much. 

Regards, 

Hello bvramilo,

Can you please try the following:

Total Batch Amount = 
SUMX(
    VALUES(Batch[IdBatch]), 
    CALCULATE(
        MAX(Batch[Amount])
    )
)