Charts and Tables display a different value whenever I make a selection.

[K1ng_Babayaga]

Hello! I've been struggling with this issue since i've joined my new company.
We have a very messy and unchangeable system that generates on a daily basis the data we work on.

I'm using the expression bellow and whenever i make a selection on the dashboard, all values change.

Sum(Aggr(count({<[Saida_De_Linha_Maior_Que_30_Dias]={'Maior'}, [Descrição Tipo Garantia]={'GARANTIA TÉCNICA PRE ENTREGA'}, [Ano Apro]={$(vAno)}>} distinct Carro), Nota))

Without any selection - Iluminação externa = 440

When i click on Iluminação externa it goes from 440 to 235.

This happens with any selection I make, always shifting numbers around.

Bellow, we have the same table we just switched orders of dimensions. Left one, we got 66 events and the same event is showing only 11 on the right one.

But when i expand the right one, the value changes yet again.

As I said, the system is really messed up and i need to find a way to display all events that a service order has generated.

Thing is, one service order[Nota] can have many cars[Carro] in it, and one car[Carro] can appear on many different orders[Nota]. 

I must find a way to properly display the real value. When i checked on the system, the correct numbers are the one that show whenever we make a selection as i'll show bellow.

On the image bellows, the service order 179636 is displaying 2 on qlik sense, because it has ONE car in it, but it has TWO events that used SINALEIRA.

The service order 180187 is also displaying correctly, because it has TWO car but only ONE sinaleira.