Percentage of count inside a Pivot table

[Justin_Yost]

Is there a way to get a "running" % of completed visits inside a pivot table based on the count. 

Example 

[#2 · Accepted solution]

@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.

[#3]

THANK YOU THANK YOU THANK YOU@Riny_van_Eekelen .

It took me a little bit, but that worked! 

[#4]

@Justin_Yost Great! Glad you could figure it out.