Forum Discussion
Measurement is not showing correct
- 2 years ago
I am sure someone esle might be able to give you a more detailed explanation but it looks like a filtering issue to me. Just a quick look at your screenshots looks like you are pullling [Inventory Quantity On Hand} from a table called WarehouseEntries and [Ongoing Order Quantity] from a table called SalesOrdersLine46.
Both of those sound like fact tables to me so they can't be joined together. Not sure where your "NO" collumn is coming from but I would check to make sure it has a relationship with both of the other tables and start there.Hope that helps a little.
- 2 years ago
Hello Jianpeng,
I drag the NO from the table connected to both Warehouse Entries and Sales Order Line and the issue was resolved. Seems I need to get the common linked column to the table if I need to have the related connected data show on the same table matrix. Thank you!
Shine
More details on the measurement DAX: