cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Anonymous
Not applicable

Showing a variance between two cards

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

1 ACCEPTED SOLUTION
Super User
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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
10 REPLIES 10
Community Support

@Anonymous ,

Have you tried dax function VARX.P()?

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

Reference:

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
Not applicable

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

Super User

@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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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.

Super User
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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

This worked! Thanks so much!

Super User
Syntax, what are you going to do? 🙂

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable
[Total Salary BY VP]-SUM(HR[Annual Rate or max(Mid-Range Rate, Last Occupant Salary) by Funding])

Works great 😀
Super User
Well, if those are display measures,

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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"

Announcements

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors