06-07-2020 07:42 PM
06-07-2020 09:49 PMSolution
@Justin_Yost Assuming you are on a Windows system (i.e. not Mac), make sure that "Add this data to the Data Model" is checked (see picture, bottom left).
Then create the PT as in your example, but leave out the last column. Then add a 'Measure' to the table in the
Name the measure and enter the DAX formula required
Add the Measure field to the PT and format it as a percentage. Then it should look like this:
The attached file contains the example shown above.