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