Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
I have been wrestling with my data model and have run up against the following sticking point.
So, as you can see, i've stuck to the star schema and tried to get all the key dimensions in there and related in one to many relationships.
My issue is with the 'incident categories' dimension table and the different levels of granularity in the 2 fact tables. So, the 'Fact' table on the left is joined to the 'Incident Categories' dimension via 'Incident Reason', of which there is a unique list in the 'Incident Categories' dimension table. However, the 2nd fact table, 'Daily Targets Test', does not have the field 'incident reason', instead it has the next level up which is 'incident category' - this rolls up the reasons into parent categories. This leaves me with no way of creating a one to many relationship between the 'Daily Target Test' and 'Incident Categories' tables, thus meaning i cannot use the 'Incident Categories' table in my reports to show actuals V target.
I hope this makes sense and assume there is a way round this?
Hi @dantheram
Can you use LOOKUPVALUE to return the values you require to the Daily Target Test table or from Daily Target Test to the Incident Category table?
Thanks heaps,
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |