Thank MudassirAli,
I have simplified the model slightly, by remove relationships on some of the lookup tables, leaving only what is required for the DAX shown in original post, hope this helps.
The image below shows the current relationships.
From the image i stand corrected, i have 3 fact tables, i previously stated only 2. Between each fact table i have bridge table a Matl No table between Reject and Confirmed tables, and Order table between Operations and Confirmed. The bridge tables I’m thinking are essential to make this work.
I will also include the Excel files in the event they are also needed.
Example 1 Rev-3.pbix (375.4 KB)
ActyAct Rev-1.xlsx (10.0 KB) Confirmations Rev-4.xlsx (30.0 KB) Operations Rev-4.xlsx (34.4 KB) Rejects Rev-3.xlsx (14.5 KB)
Many thanks
J