Forum Discussion

Justin_Yost's avatar
Justin_Yost
Copper Contributor
Jun 08, 2020
Solved

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

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
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