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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.