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

MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
6 years ago

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?

v-lid-msft's avatar
v-lid-msft
Community Support
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.

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

    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.