Forum Discussion
mb0307
Responsive Resident
Responsive ResidentDax calculation- help needed
Hi Team, I have scenario… Orders are raised in the 1st ERP system that is EA, then pulled to second ERP system X3 after that sales invoices are raised in x3. We want to match the discounts and cha...
lbendlin
Super User
Super UserThe data model isn't too bad
It looks like the EACustomer table can be eliminated, and it looks like you are missing the "Sales Orders" dimension. Once you add that you can remove the inactive relationships between the fact tables, and your measures will start working.
Please read up on the usage of TREATAS(), it will come in very handy here.