Forum Discussion
Justin_Yost
Jun 08, 2020Copper Contributor
Percentage of count inside a Pivot table
Is there a way to get a "running" % of completed visits inside a pivot table based on the count. Example
- Jun 08, 2020
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.
Justin_Yost
Jun 08, 2020Copper Contributor
Riny_van_Eekelen
Jun 08, 2020Platinum Contributor
Justin_Yost Great! Glad you could figure it out.