Measure shows three different numbers when the filters are the same

[alanoec]

Hi guys, 

I've encountered an issue that I am stumped on. The column TEU BY VESSEL is a measure:

= CALCULATE([TOTAL TEU],ALLEXCEPT(VV,VV[World Region by Place of Receipt],VV[VV])). 

When I display it, there should only be 1 number: 10,027, but there are 3 numbers: 10,027, 5,384, and 4,643. 

5,384 and 4,643 add up to 10,027 so I am confused on why that is the case here. 
 

Thank you!

[smpa01 · Accepted solution]

@alanoec  can you try the following

CALCULATE([TOTAL TEU],ALLEXCEPT(VV,VV[VV]))

[alanoec]

@smpa01 

Thank you for this suggestion. Upon using your formula, I see that the total value is 10,901 which was higher than the total amount. So I went looking into the data and saw that the region filters are the reason why its giving three numbers. 

Loader A only loads from region 1: SUM is 5384.
Loader B only loads from region 2: SUM is 4643.
Loader C loads from regions 1 and 2 so SUM is 10,027. 

Thank you so much for the suggestion and sorry for the late reply!

[themistoklis]

@alanoec 

Can you try the following formula and see what it returns?

= CALCULATE([TOTAL TEU],ALL(VV)). 

[alanoec]

@themistoklis Thank you for replying!

the answer is consistent for all columns. 

[themistoklis]

@alanoec 

What is the formula that you use for this measure?

[TOTAL TEU]

If you could share the file with us that would help. 

[alanoec]

@themistoklis 

The formula for total TEU is = 

SUM(VV[Teus]). 

Unfortunately, there is a restriction for me sharing the file. 

However, there's also the issue of the table visualization and card visualization showing different values for the same measure. filters are the same.