Forum Discussion
Compare measures from different facts
Hi , I am trying to compare budget and actuals for an employee at row level and cost centre in colum level in matrix format .. Actuals and budgets data are in facts with person , FY , period & cost c...
Hi Anonymous ,
If there is a correct relationship between your two tables, you can directly add them to the matrix for comparison, if not, you need to create two measures for the two tables to get the values of Actuals and Budgets, and compare them in the matrix.
If it’s not clear, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.