Forum Discussion
Showing a variance between two cards
- 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 ,
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.
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.