Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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 centre columns.. and employee details in a separate table.. what is the best way to model this ? Thanks

4 REPLIES 4
Community Support

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.

Community Support

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

``````Measure =
SWITCH(
TRUE(),
SUM('Table'[budget])>SUM('Table'[actuals]),"Budget big",
SUM('Table'[budget])<SUM('Table'[actuals]),"Actual big",
SUM('Table'[budget])=SUM('Table'[actuals]),"equal")``````

2. Open the matrix and place the columns and [Measure] in the following form.

3. Result:

Compare budget and actuals:

Does this meet your expectations.

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

Anonymous
Not applicable

Hi Yangliu,

In my case Budget & Actuals data are in different fact tables and I want to be able to drag them on my matrix to compare both values for a given dimension? is this possible? thanks

Super User

Hi @Anonymous

Your request is not clear, can you please open the below link and read that:

How to Get Your Question Answered Quickly

Appreciate your Kudos!!

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors