Forum Discussion

_chris_'s avatar
_chris_
Helper III
2 years ago

Problem with Table total (no measure)

Hi,   I am encountering a strange behavior with the table visual. The sum of the DauerTD column does not equal the sum of the total while the total is correct:   In SQL my dataset looks lik...
Need Help
_chris_'s avatar
_chris_
Helper III
2 years ago

Hi Tom,

 

thanks for your reply. However, unfortunately, this does not help. I have two tables which are connected through a link key. With relation activated, the error occurs:

 

Turning off the relation and filtering for this link key gives me all lines of data. You can see that in the detail table the link key is set correctly

 

Turning on the relation again and enabling "Show elements without data" gives the following:

 

To me this does not make any sense... 

 

Any other idea?

 

Thx, Christian

TomMartens's avatar
TomMartens
Super User
2 years ago

Hey _chris_ ,

 

assuming both tables are related by 1-to-many relationship the problem you are facing is an indication that keys from the table of the many-side are missing in the table on the one-side.

 

From the screenshots the origin of the linkkey column is not clear.

 

An easy way to spot the existence of missing values is

  • create a slicer from the linkkey column from the table on the one-side (make sure the relationship is activated

I'm pretty sure that first element of the slicer is (Null)

 

Hopefully this helps to tackle your challenge.

 

Regards,

Tom