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
MiguelSaldana77
Resolver I
Resolver I

Elements without information

Hi Everybody, I have a design question.

The example is a very small situation of the real data.

I need to make a Dashboard that shows all the accounts of their respective company (even accounts worthless).  The image shows The fact table and 2 dimension tables.


In order to show just the account  of the respective company,  I have the idea to include the company in the Account table and make certain hierarchy, but I have a doubt, how to make the relation between the others 2 tables.

 

Image1.jpg

 

 

 

 

 

1 ACCEPTED SOLUTION

Hi @MiguelSaldana77 ,

 

We can use the measure to meet your requirement as a workaround if you just want the total value.

 

18.PNG

16.PNG17.PNG

 

 

 

BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
v-lid-msft
Community Support
Community Support

Hi @MiguelSaldana77 ,

 

If you wan to show the different table in different pages, we can add diffenet slicers as following.

 

14.PNG15.PNG17.PNG

 

The relation I used is as the fact table in center.

 

16.PNG

 


If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks  @v-lid-msft 
I made changes to your example (. pix) because I tried to show how I did to show the Accounts without values, but now I have another problem. I Added a new table and information to the Fact Table this is the country and I have the same original problem, I need to show the information by country and show those countries with no data, as shown in the image. I attach the  .Pbix 
----> 
Elements-without-informationChange2.jpg

Hi @MiguelSaldana77 ,

 

After adjust the relation, I can show the missed country. Do you want to show the A5 both?

 

17.PNG16.PNG

 

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-lid-msft 

Yes, I need to show A05 (both), I think that we need to resolve this problem by Calculate command filtering with tables filtered by compañia for the accounts and countries. What do you think?

Hi @MiguelSaldana77 ,

 

How about the result after you follow the suggestions mentioned in my previous post?

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @MiguelSaldana77 ,

 

We can use the measure to meet your requirement as a workaround if you just want the total value.

 

18.PNG

16.PNG17.PNG

 

 

 

BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @MiguelSaldana77 ,

 

I am sorry that I cannot edit the above reply, so I put addition explanation here.

 

The common usage of relation in your case is use fact table as the center, all the data will be normal, but when use company to filter the account, it will across the fact, the company 1 in fact table has no A05 account, so it will not display A05 in the matrix, so the country SALVADOR is the same. And the fact table need all the company, country and account to calculate totol correctly.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I made a test and now this change Work
Do you think this change will cause a Problem?


Change.jpg

Thanks so much for responding, I actually have the same relation between tables, the problem is that I need to show just the accounts of the corresponding company, that is why I was thinking add the company at the “ACCOUNT” table. If I add the company at “Account” table, Could I related the table “Account” and “Company” table?? And If It is possible, when I filter a Dashboard by company, Will be appear Just the Companies´s Accounts?

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.

Top Solution Authors