Forum Discussion

Raph's avatar
Raph
Helper III
3 years ago
Solved

Detecting values with referential integrity problem

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

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

     

     

1 Reply

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