Hello there. I am trying to improve my modelling technique. I realise my model will change sometimes based on the types of measures I want to create. However right now I'm just trying to do my initial "logical modelling." I'm more than happy to upload the data if needed.
Question 1: For the below, for any seasoned data modellers out there with strong DAX capabilities - can you see any floors in my design?
Question 2: Is it "right" that I have hidden the Orders table? Or should I simply rather combine the Orders and OrderDetails tables, and just have one table... would it make my DAX simplier?
Question 3: I am a bit concerned that I have two dimension tables (Pizzas, PizzaTypes) on top of one "fact" table. Is this okay, is there a special way I would have to handle the DAX here?
Question 4: I never know which table is best practice to hide the "id" column. For example, should I hide "pizza_type_id" on the OrderDetails table (but not the PizzTypes table).
Thanks in advance, Michelle
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
