Showing a variance between two cards

[Anonymous]

I am new to Power BI and I would like to have a 3rd card to the right of "Total Salaries" that shows the variance between "Total FY20 Budgeted Salaries" and "Total Salaries". How can I do this? Screen shot below

[v-yuta-msft]

@Anonymous ,

Have you tried dax function VARX.P()?

VARX.P(<table>, <expression>)  

Reference:

https://docs.microsoft.com/en-us/dax/varx-p-function-dax 

Community Support Team _ Jimmy Tao

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

[Anonymous]

@v-yuta-msft 

I tried this but it does not look like it is applying the filters properly

[Greg_Deckler]

@Anonymous - Question, do you want the variance or the difference? If you do not already have measures for your cards and are using an aggregation over a column, you need to wrap an aggregation around things like:

Third Measure = SUM('Table'[Column]) - SUM('Table'[Other Column])

But, that is for a difference, not a true variance. @v-yuta-msft is talking about a true variance whereas I made the assumption that by variance you were really saying you wanted the difference between the numbers.

[Anonymous]

@Greg_Deckler 

Yes you are correct, I just mean the difference.

When I try that it does not give me the option for the 'Total Salary BY VP' column from the Budget table.

[Greg_Deckler · Accepted solution]

You need to close your paren for your first SUM right before the - sign, put a )

It looks like your Total Salary BY VP is a measure, you should just be able to use [Total Salary BY VP] with no SUM. Measures do not need aggregations around them.

[Anonymous]

@Greg_Deckler 

This worked! Thanks so much!

[Greg_Deckler]

Syntax, what are you going to do? 🙂

[Anonymous]

[Total Salary BY VP]-SUM(HR[Annual Rate or max(Mid-Range Rate, Last Occupant Salary) by Funding])

Works great 😀

[Greg_Deckler]

Well, if those are display measures,

Third Measure = [Total FY20 Budgeted Sales] - [Total Salaries]

[Anonymous]

@Greg_Deckler 

When I try to do that, it does not give me the option to use the budgeted amount. See Screen shots. The budgeted amount is coming from the budget table and is called "Total Salary by VP"