SOLVED

Percentage of count inside a Pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-1447329%22%20slang%3D%22en-US%22%3EPercentage%20of%20count%20inside%20a%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447329%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20get%20a%20%22running%22%20%25%20of%20completed%20visits%20inside%20a%20pivot%20table%20based%20on%20the%20count.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Justin_Yost_0-1591583862767.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197144iB111E32B5FD7DC18%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Justin_Yost_0-1591583862767.png%22%20alt%3D%22Justin_Yost_0-1591583862767.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1447329%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447467%22%20slang%3D%22en-US%22%3ERe%3A%20Percentage%20of%20count%20inside%20a%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447467%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691896%22%20target%3D%22_blank%22%3E%40Justin_Yost%3C%2FA%3E%26nbsp%3BAssuming%20you%20are%20on%20a%20Windows%20system%20(i.e.%20not%20Mac)%2C%20make%20sure%20that%20%22Add%20this%20data%20to%20the%20Data%20Model%22%20is%20checked%20(see%20picture%2C%20bottom%20left).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-08%20at%2006.33.37.png%22%20style%3D%22width%3A%20389px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197161i14216CDBFAC8E18D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-06-08%20at%2006.33.37.png%22%20alt%3D%22Screenshot%202020-06-08%20at%2006.33.37.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20create%20the%20PT%20as%20in%20your%20example%2C%20but%20leave%20out%20the%20last%20column.%20Then%20add%20a%20'Measure'%20to%20the%20table%20in%20the%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-08%20at%2006.37.48.png%22%20style%3D%22width%3A%20231px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197162i5CE04B6ECFD1B493%2Fimage-dimensions%2F231x82%3Fv%3D1.0%22%20width%3D%22231%22%20height%3D%2282%22%20title%3D%22Screenshot%202020-06-08%20at%2006.37.48.png%22%20alt%3D%22Screenshot%202020-06-08%20at%2006.37.48.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EName%20the%20measure%20and%20enter%20the%20DAX%20formula%20required%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-08%20at%2006.39.28.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197163i79914677A0787DAB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-06-08%20at%2006.39.28.png%22%20alt%3D%22Screenshot%202020-06-08%20at%2006.39.28.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAdd%20the%20Measure%20field%20to%20the%20PT%20and%20format%20it%20as%20a%20percentage.%20Then%20it%20should%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-08%20at%2006.42.41.png%22%20style%3D%22width%3A%20457px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197165i9F56651AF40EB368%2Fimage-dimensions%2F457x153%3Fv%3D1.0%22%20width%3D%22457%22%20height%3D%22153%22%20title%3D%22Screenshot%202020-06-08%20at%2006.42.41.png%22%20alt%3D%22Screenshot%202020-06-08%20at%2006.42.41.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20attached%20file%20contains%20the%20example%20shown%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447517%22%20slang%3D%22en-US%22%3ERe%3A%20Percentage%20of%20count%20inside%20a%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447517%22%20slang%3D%22en-US%22%3E%3CP%3ETHANK%20YOU%20THANK%20YOU%20THANK%20YOU%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20took%20me%20a%20little%20bit%2C%20but%20that%20worked!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447524%22%20slang%3D%22en-US%22%3ERe%3A%20Percentage%20of%20count%20inside%20a%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691896%22%20target%3D%22_blank%22%3E%40Justin_Yost%3C%2FA%3E%26nbsp%3BGreat!%20Glad%20you%20could%20figure%20it%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

Example 

Justin_Yost_0-1591583862767.png

 

3 Replies
Highlighted
Best Response confirmed by Justin_Yost (New Contributor)
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).

Screenshot 2020-06-08 at 06.33.37.png

Then create the PT as in your example, but leave out the last column. Then add a 'Measure' to the table in the 

Screenshot 2020-06-08 at 06.37.48.png

Name the measure and enter the DAX formula required

Screenshot 2020-06-08 at 06.39.28.png

Add the Measure field to the PT and format it as a percentage. Then it should look like this:

Screenshot 2020-06-08 at 06.42.41.png

The attached file contains the example shown above.

 

Highlighted

THANK YOU THANK YOU THANK YOU@Riny_van_Eekelen .

 

It took me a little bit, but that worked! 

Highlighted

@Justin_Yost Great! Glad you could figure it out.