Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
You need to use the Ref column from the dimension table.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
69 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |