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.
In your measure, you should probably use HASONEVALUE on your Month and if so, return BLANK(), otherwise, do your calculation.
Proud to be a Datanaut!
Please share sample data of your table and post expected result following the guide in https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
We will provide you appropriate DAX based on your sample data.