Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
_chris_
Helper II
Helper II

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:

 

_chris__0-1694333482633.png

In SQL my dataset looks like this. The data for the red marked area is missing in PowerBI

 

_chris__1-1694334482381.png

 

No measure is involved, no filters applied and also I did refresh PowerBI a couple of time.

 

I have no clue how this can happen. Does someone have an idea?

 

Thanks and a good sunday to everone!

 

Christian

5 REPLIES 5
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
TomMartens
Super User
Super User

 Hey @_chris_

 

it looks like you have created a data model where the table that contains "Projekt" is related to your SQL table.

My assumption is that the missing row from the SQL has no relation to the "Project" table, meaning that the value from the related SQL table is blank or the value is missing in the related project table.

 

Hopefully, this provides an idea of how to tackle your challenge.

 

Regards,

Tom 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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:

 

_chris__0-1694345860462.png

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

 

_chris__1-1694345993671.png

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

_chris__1-1694348762665.png

 

To me this does not make any sense... 

 

Any other idea?

 

Thx, Christian

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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.

 

_chris__0-1694363701286.png

 

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

 

Thx, Christian

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.