cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cel13 Frequent Visitor
Frequent Visitor

Trying to get a Average of a Percent Complete by Phase

I am struggling to be able to get the Correct % Complete by phase for the data I have. I have a column that is my percent complete and I would like to have an average of percent complete by phase.  I know i have Percentages of 0%, 65%, and 80% and i shouldnt be seeing 340%

 

Anything I do, it shows the incorrect data. Any help would be greatly appreciated. Essentially I am trying to recreate this from excel.Capture1.PNG

Capture.PNG

 

5 REPLIES 5
Super User
Super User

Re: Trying to get a Average of a Percent Complete by Phase

@cel13 

Please share a sample of your data in a format that can be copied (paste it into the post from excel, not a screen shot) and include samples from each table involved.  I looks like Phase - Tier 1 might be coming from a different table since you have no amounts appearing under anything but the blank.  Also an example of the expected outcome.  We will need this information in order the help write the measures.

cel13 Frequent Visitor
Frequent Visitor

Re: Trying to get a Average of a Percent Complete by Phase

Here is a snip bit of the data (which is still in progress of being built out as to why there are blanks): 

 

 

Phase - Tier 1                 % Complete
                                       0%
                                       80%
                                       65%
Risk Assessment             0%
Reporting                       0%
Substantive - Final         0%
Substantive - Interim     0%

Super User
Super User

Re: Trying to get a Average of a Percent Complete by Phase

Does this match your expected result?

Avg % Complete = AVERAGE ( YourTable[% Complete] )

PctComplete.jpg

cel13 Frequent Visitor
Frequent Visitor

Re: Trying to get a Average of a Percent Complete by Phase

@jdbuchanan71 I can't get the measure you meantioned to show the same thing: 

 

Capture.PNG

Super User
Super User

Re: Trying to get a Average of a Percent Complete by Phase

@cel13 

Can you share your .pbix file?  You can upload it to OneDrive or DropBox and share the link here.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 170 members 1,710 guests
Please welcome our newest community members: