Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
spatialcoder
New Member

Determining the overall progress of a project by the total progress of the tickets assigned to it.

Hi All, 

 

I have a task that requires me to be able to define the progress of a project. Below is the scenario.

 

I have a data table with a column that has Project Names in it, and for each project there can be more than one task/ticket associated to it. Each task has a progress complete column with (fake data) that ranges from 0-100. The data looks something like this:

spatialcoder_0-1701358817913.png

 

What I am seeking to do is to be able to display a total progress completion percentage for all of the tickets for each project. The percentage should total up to 100%. We have to keep in mind that the number of tasks could easily vary and isn't always the same as the screenshot shows for this sample.

 

Is there a way to do this using Dax? Id like to display this in a card as well.

 

 

1 ACCEPTED SOLUTION
Ced-Alcaraz
Regular Visitor

@spatialcoder 
Measure

Overall Progress =
var _countTick = DISTINCTCOUNT('table'[Ticket ID])
var _Sumprogress = CALCULATE(SUM('table'[Progress Complete]))
RETURN
_Sumprogress / _countTick / 100
CedAlcaraz_0-1701394123483.png

 



View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

The solution below assisted me in the ask. 

 

I will do so in my next post for sure.

Ced-Alcaraz
Regular Visitor

@spatialcoder 
Measure

Overall Progress =
var _countTick = DISTINCTCOUNT('table'[Ticket ID])
var _Sumprogress = CALCULATE(SUM('table'[Progress Complete]))
RETURN
_Sumprogress / _countTick / 100
CedAlcaraz_0-1701394123483.png

 



This did help alot. I was stuck in the process of sorting the position where this should go. 

 

Ths only other thing I do have as a question is if there is a way to control the percentages it reports? 

 

Right now I have a total reading 0.xx % is there something in the UI to configure that will give me somewthing like 85.0 % instead of 0.85 %?

@spatialcoder 
Yes, click on your measure then go to measure tools. See highlighted.

CedAlcaraz_0-1701738013706.png

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.