Forum Discussion

Justin_Yost's avatar
Justin_Yost
Copper Contributor
Jun 08, 2020

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   
  • Riny_van_Eekelen's avatar
    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.

     

Resources