Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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