Hi,please I have the following example:what i need is the following as output, is a tabl that shows for me per project ID and per Phase if all task status = Completed , I will get under task status 100% if it includes both completed and in progress, he will calculate the % of completed tasks over total tasks for that project ID & same Phase. Project IDTask statusPhase1CompletedPH#11CompletedPH#11CompletedPH#11CompletedPH#11CompletedPH#11CompletedPH#11In progressPH#21In progressPH#21CompletedPH#22CompletedPH#12CompletedPH#12CompletedPH#12In progressPH#12CompletedPH#22CompletedPH#22CompletedPH#22CompletedPH#22CompletedPH#22In progressPH#22In progressPH#22In progressPH#22CompletedPH#32CompletedPH#3

Okay, for that you just need to drag these 3 column on the table visual.

need help | Microsoft Fabric Community

5 Replies

Samarth_18

Community Champion

4 years ago

Hi Zakaria_1980 ,

You could create a column as below:-

Column =
VAR completed_task =
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[Project ID] = EARLIER ( 'Table'[Project ID] )
                && 'Table'[Phase] = EARLIER ( 'Table'[Phase] )
                && 'Table'[Task status] = "Completed"
        )
    )
VAR total_task =
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[Project ID] = EARLIER ( 'Table'[Project ID] )
                && 'Table'[Phase] = EARLIER ( 'Table'[Phase] )
        )
    )
RETURN
    IF ( total_task = completed_task, 1, DIVIDE ( completed_task, total_task ) )

Refer a attached file.

Output:-

BR,

Samarth

_Sample.pbix25 KB

Zakaria_1980
Post Patron
4 years ago
Thanks for this output, but can we have sth simple like this:

Project ID Phase Status Completion
1 PH#1 100%
1 PH#2 33%
2 PH#1 75%
2 PH#2 63%
2 PH#3 100%
- Samarth_18
  Community Champion
  4 years ago
  Zakaria_1980 You can adjust your decimals from here.

Project ID	Task status	Phase
1	Completed	PH#1
1	Completed	PH#1
1	Completed	PH#1
1	Completed	PH#1
1	Completed	PH#1
1	Completed	PH#1
1	In progress	PH#2
1	In progress	PH#2
1	Completed	PH#2
2	Completed	PH#1
2	Completed	PH#1
2	Completed	PH#1
2	In progress	PH#1
2	Completed	PH#2
2	Completed	PH#2
2	Completed	PH#2
2	Completed	PH#2
2	Completed	PH#2
2	In progress	PH#2
2	In progress	PH#2
2	In progress	PH#2
2	Completed	PH#3
2	Completed	PH#3

Project ID	Phase	Status Completion
1	PH#1	100%
1	PH#2	33%
2	PH#1	75%
2	PH#2	63%
2	PH#3	100%

Forum Discussion

need help