Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Exclude Part of Quick Measure Variance in Matrix

I have a table of budget and actual information. I want to be able to only show the diference--my Over/(Under) column on the right. I don't need to know see the variance in the actual column. How can I go about structuring this? Does my quick measure need to be tweaked?

Anonymous,

Try these measures:

Actual Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Actual" )

Budget Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Budget" )

Over/(Under) = [Budget Dollars] - [Actual Dollars]

Create matrix visual:

1 Reply

Super User

Anonymous,

Try these measures:

Actual Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Actual" )

Budget Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Budget" )

Over/(Under) = [Budget Dollars] - [Actual Dollars]

Create matrix visual:

Related content