Forum Discussion
why does measure affect filter context in matrixI
Hi arunbyc ,
I think your issue should be caused by the relationship between Order Table and Work Table.
Here I create a sample:
In my sample Order[Order_Id] connect to Work[Order_Id] (one to many)
Result is similar like yours:
You can update your measure as below.
Rate = CALCULATE(DIVIDE(sum('Order'[Est_Amount]),sum('Order'[Est_Quantity])),CROSSFILTER('Order'[Order_Id],'Work'[Order_id],Both))I am confused to your data model. I think Work Table should be a DimTable for Order Table like Project Table.
Can an order id correspond to more than one work id and name, otherwise I think the relationship should be one to one.
If relationship looks like as below, your measure works.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi arunbyc
The the Work table can't be used in this scenario. Although it has a relationship with the Order table, the Order table only filters the Work table not the other way round. So when adding the column from the work table, this is the expected result.
What are you trying to acheive? If you want to show just the Work done, then add an extra table, when someone clicks on an Order in the first visual, this will filter the new table with the work.
Let me know what you want to acheive and I can take a look for you
Joe
No I am not adding a column from the work table. I posted my model in the same thread in reply to dharmendars007. Can you pls see and let me know what you think?