Forum Discussion

_chris_'s avatar
_chris_
Icon for Helper III rankHelper III
3 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
Icon for Super User rankSuper User
2 years ago

Hey _chris_ ,

 

A bug is very unlikely; 1-to-many relationships are at the core of the Power BI dataset.

 

One thing you can try is to use the clean and trim functions inside Power Query on the linkkey columns in both tables to get rid of nonvisible characters.

 

Without having access to the pbix I assume it's difficult to provide further guidance.

 

Sure, open a case with MSFT.

 

Regards,

Tom