Fill Handle Not Working. Is there a better way to do this?

johnsboxftm 

To create a custom measure in Power Pivot, you need to use the Data Analysis Expressions (DAX) formula language.

Here’s an example of how you can create a custom measure that concatenates the dollar amount variance and its percentage variance into a single text string:

1. Open the Power Pivot window by clicking on the “Power Pivot” tab in the ribbon and selecting “Manage”.
2. In the Power Pivot window, select the table where you want to create the custom measure.
3. Click on the “Measure” button in the “Calculations” group of the “Home” tab.
4. In the formula bar, enter a DAX formula that calculates the dollar amount variance and its percentage variance and concatenates them into a single text string.

For example: 

Variance = FORMAT([Sales]-[Last Month],"$#,##0") & " (" & FORMAT(([Sales]-[Last Month])/[Last Month],"0.0%") & ")".

Make sure to replace [Sales] and [Last Month] with the appropriate measure names for your data.

1. Press Enter to save the measure.

You can now add this custom measure to your Power Pivot table to display both the dollar amount variance and its percentage variance in the same cell.

I hope this helps!