Fill result with N/A when DIM has no value

[RonSon2015]

Hello,

I've got a case where I have a fact table that is connect to a DIM table via a bridge table (many to many relationship).

However, the DIM tables has not only duplicate values but also less attributes than the fact table. Thus, the result by item differs from the grand total. What could be an elegant way to solve the issue? Combine the duplicates to have it as one result or is there any chance to fill the items with N/A where no value in DIM table is available?

Thanks for any tipps and tricks!

Here is an small example:

[v-yanjiang-msft · Accepted solution]

Hi @RonSon2015 ,

According to your description, if you want to fill result with N/A when DIM has no value, you can try like this:

If you want to combine the duplicates to have it as one result, you can add a row to the Dim table, and filter the duplicate supplier.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@RonSon2015 , not very clear. You should supplier from supplier table and product from product table. if some supplier or product ar missing(because of data in fact) you can use +0 in measure or use show item with no data. 

[RonSon2015]

Hello @amitchandak 
thank you for the quick reply. You are right, the setup with one table with supplier and product is not optimal. However, it was just to indicate the problem of missing information in dimensional table whereas the information form dimensional table shall be displayed in a visual.

Can you give me a hint regarding the "+0 in measures". How would you do it?