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
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

_chris_'s avatar
_chris_
Helper III
2 years ago

Thanks again, I tested everything. I have a proper 1:n relationship, no NULLS and no double values on the 1 side. Now I put the LinkKey field from the master and from the detail table as you can see. The LinkKey matches 100% but still no data is shown.

 

 

How likely is a bug in PowerBI? Would you recommend to open a case with Microsoft?

 

Thx, Christian