Showing results for 
Search instead for 
Did you mean: 
analyst31 Regular Visitor
Regular Visitor

Budget to Actual variance in a matrix

I have a financial report that i have created, it is almost complete and the last part is to add a budget to actual variance column in the matrix. I am trying to get it to the right of the "Totals Column". I tried creating a new measure, but it was breaking it up by months and summing the variance together, i tried to click on "dont summarize" option on the values drop down, but it was not there.


Here is what the reports looks like so far


Super User
Super User

Re: Budget to Actual variance in a matrix

In your measure, you should probably use HASONEVALUE on your Month and if so, return BLANK(), otherwise, do your calculation.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-yuezhe-msft

Re: Budget to Actual variance in a matrix


Please share sample data of your table and post expected result following the guide in

We will provide you appropriate DAX based on your sample data.


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.