Filtering the two fact tables orders sales and cancellations from a query that sums two fact tables

[akhaliq7]

i have a complicated situation whereby I have an orders sales table and I have another table which is an orders cancellations table. I want to create a third table which I can use as filters, But in this I want the rows to match the sales minus the cancellations but I want to show all the categorical values which I can use to filter. Would I need to do some kind of aggregation maybe.

if someone with experience in this question can help thanks

[PaulDBrown · Accepted solution]

Please provide sample data or a PBIX file and a depiction of the expected outcome

[akhaliq7]

i am using another way to do this