Detecting values with referential integrity problem

[Raph]

Hello,

I have a model which aims to calculate royalties on sales. There is a fact table displaying the sales by product, a REF table which is the products dimension table and finally a Royalties table displaying all the royalties rates. When a product (= a reference) appears in the royalties table but  does not exist in the product table, the returned value is the total revenue of all missing values (no surprise) : 

Is there any mean to replace these values by an error message or by a blank cell because the current view is quite confusing?

Please find below the link to download the PBIX file : 

https://drive.google.com/file/d/1PPXpKB_v8AkmfFEA621qKj-_9G5LEsel/view?usp=sharing

Thank you in advance for your help.

Raphaël

[lbendlin · Accepted solution]

You need to use the Ref column from the dimension table.