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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
RonSon2015
Frequent Visitor

Fill result with N/A when DIM has no value

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?

 

2021-11-09_13h34_21.png

 



 

 

 

 

 

 

Thanks for any tipps and tricks!

 

Here is an small example:

 

2021-11-09_13h49_17.png2021-11-09_13h48_49.png2021-11-09_13h48_39.png2021-11-09_13h48_25.png

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

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:

vkalyjmsft_0-1636681381423.png

 

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.

vkalyjmsft_1-1636681381427.png

 

vkalyjmsft_2-1636681381430.png

 

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.

View solution in original post

3 REPLIES 3
v-yanjiang-msft
Community Support
Community Support

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:

vkalyjmsft_0-1636681381423.png

 

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.

vkalyjmsft_1-1636681381427.png

 

vkalyjmsft_2-1636681381430.png

 

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
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.