Forum Discussion
Helper IIMeasurement is not showing correct
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.
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
Hi, Shineccx007
Thanks cdcarnes . In your report, are the No columns used by the two table visuals the same column? Also, Salesordersline46 may have an impact on the Inventory Quantity on hand measure. You should add an option to clear this filter in this measure, something like ALLSELETED('Salesordersline46'[Quantity]). This should clear out the effects of external filtering, which you can try.
By looking at your DAX expressions, you see that multiple tables are involved, so you check the relationships between the tables to make sure they are correct.
If you can provide a sample PBIX file that does not contain private data, it will quickly help you solve the problem at hand.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Shineccx007Hello 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