data model
3 Topics
Matrix Table - keeps on repeating
Hi! Would appreciate insights on where my model is going wrong. I have these tables: (1) Base headcount of employees w/c I am planning to use as dimension (2) Data that would be used for the measures - this table has a person identifier that could be linked to table 1 (3) Dimension table for Region, Business Unit and Country Basically, the stakeholder would want a visual and table that shows how many employees meets the metrics and how many are not. So the table 1 have a mapping of region and business unit per employee w/c was then connected to table 3. Now, the issue is the matrix table. Since they would want as well the list of workers that does not have data in table 2, I have added +0 at the latter part of the DAX that simply count the rows, sum some data, etc. What happens is that, if I visualize it as a table: Region - Business Unit - Worker, the worker appears to ALL regions and BUs w/c should not be the case. Any insights on where did I went wrong? Any help would be appreciated 🙂Solved1.1KViews0likes3Comments
Data Model Question - Sales Order Line and Shipment Details
I need some help to model my order management data. I have some dimensions such as customer (sold to, ship to, bill to), product, orgaization and Caledar with 2 fact tables Sales Order Line details and Shipment details. The two fact tables have a common column "SalesOrderLineId". I was advided to create a DimSalesOrderLines dimension so that I can put order line and shipment details together (side by side). I have surrogate key from Sale Order line Fact table added to shipment details table based on "SalesOrderLineId". I dulicated the table and renamed it as DimSalesOrderLine. Created relationship between DimSalesOrderLine and FactSalesOrderLine on the same surrogate key "One to One" and double direction. When I tried to create relationship between DimSalesOrderLine and ShipmentDetails on the surrogate key, Power BI gives me error message "Cannot create active relationship as it will introduce ambiguity between bill to customer and shipment details? How do I model this so that I can put together the information from both the facts together such as any text information. Thanks in advnce for your help.insights.Solved6.2KViews0likes5Comments
