Forum Discussion
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
- lbendlinSuper User
You need to use the Ref column from the dimension table.