DAX to pull costs from different table using relationships and CROSSFILTER

DAX DAX Calculations
1

Hi - please see tab “New COGS example” in the attached pbix file. I am trying to show sales amt/cost amount/margin per works order number.
There is a relationship between SO_DETAIL and WO_HIST_HD

I have tried CROSSFILTER to pull through the costs from the CN_SALES_CC (costs) table which seems to work with the WO number. But despite the relationship I can’t get the WO number, sales and costs on the same line, I tried ALLSELECTED too but I am getting in a tangle!!

Grateful to receive any help, thanks Lizzie
Removed pbix with sensitive data - will replace with dummy data model soon, thanks

1 Like
2

Hello @LizzieTompsett. Here are some videos that may help you masking sensitive data and create datasets and data models representative of your problem:

3

Hello @LizzieTompsett, just following up on the PBIX file you mentioned above.
We haven’t heard from you since August 19.

If there won’t be activity from you in the coming days, we’ll be tagging this thread as solved.

4

Hello - I resolved this, the issue was I hadn’t changed the relationship direction on the tables using the CROSSFILTER to “both” all working now albeit quite laggy, thanks