Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
6 years ago
Solved

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.

 

 

 

 

 

 

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi MiguelSaldana77 ,

     

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

     

     

     

     

    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.

9 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi MiguelSaldana77 ,

     

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

     

     

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

     

     


    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.

    • MiguelSaldana77's avatar
      MiguelSaldana77
      Resolver I
      6 years ago

      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?

    • MiguelSaldana77's avatar
      MiguelSaldana77
      Resolver I
      6 years ago

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


    • MiguelSaldana77's avatar
      MiguelSaldana77
      Resolver I
      6 years ago

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

      • v-lid-msft's avatar
        v-lid-msft
        Community Support
        6 years ago

        Hi MiguelSaldana77 ,

         

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

         

         

         

        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.