Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
4 years ago
Solved

need help

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 stat...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

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

     

Samarth_18's avatar
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

  • Zakaria_1980's avatar
    Zakaria_1980
    Post Patron
    4 years ago

    Thanks for this output, but can we have sth simple like this:

     

    Project IDPhaseStatus Completion
    1PH#1100%
    1PH#233%
    2PH#175%
    2PH#263%
    2PH#3100%
    • Samarth_18's avatar
      Samarth_18
      Community Champion
      4 years ago

      Zakaria_1980 You can adjust your decimals from here.

       

      • Zakaria_1980's avatar
        Zakaria_1980
        Post Patron
        4 years ago

        The problem is not the format of the decimal but the output itself, i've shared with you the output i need, what i did is that i regrouped by project id and phase to get the status completion %.