Forum Discussion
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
- 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.
10 Replies
- Well, if those are display measures,
Third Measure = [Total FY20 Budgeted Sales] - [Total Salaries]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"
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 - 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.
