Calculate difference from two facts table

Hi,

Thanks for the solutions Ashish_Mathur  and DataNinja777  provided, and i want to offer some more information for user to refer to.

hello DataNinja777 , based on your description, you can refer to the following solution.

1. Create a new table named company.

Company = DISTINCT(UNION(VALUES(Expense[Company Code]),VALUES(Revenue[Company Code])))

2.Create 1:n relationships among company, expense,revenue table. the key column is company code.

3.Create the following measures

Revenue = SUM(Revenue[Revenue])

Cost = CALCULATE(SUM(Expense[Expenses]),CROSSFILTER(Company[Company Code],Revenue[Company Code],Both))

EBIDTA = [Revenue]-[Cost]

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.