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? Scree...
- 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 - 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.
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.
- 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.- Syntax, what are you going to do? 🙂