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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
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 belowVariance Question.PNG

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

10 REPLIES 10
v-yuta-msft
Community Support
Community Support

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

@v-yuta-msft 

 

I tried this but it does not look like it is applying the filters properlyvarpx.PNG

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

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

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

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.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

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

@Greg_Deckler 

 

This worked! Thanks so much!

Syntax, what are you going to do? 🙂


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

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 😀
Greg_Deckler
Super User
Super User

Well, if those are display measures,

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

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

@Greg_Deckler Total salaries.pngTotal salaries2.png

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"

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.