Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Percentage Column Help

Hi

 

I need some help with a dashboard i am creating. I have 1 data dump out of Primavera p6 but need to either have a seperate sheet or another way to look at the below columns and calculate a %.

 

1 - Planner name

2 - Activity Status

3 - Missing Logic

 

I need to show a graph to show each of the planners, the remaining activities (Activity status doesnt equal Complete) and "Missing Logic". This is probably really easy but its baffled me. As a % of the remaining activities. 

 

Please help.

Cheers, Keith 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Check this formula.

    Measure = 
var remain = COUNTX(FILTER('Table','Table'[activity status]<>"finished"),'Table'[planner])
var missing = COUNTX(FILTER('Table','Table'[activity status]<>"finished"&&'Table'[logic]="missing logic"),'Table'[planner])
return
missing/remain

    Result would be shown as below.

     

     

    Best Regards,

    Jay

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Im not sure if this will work or not. and cant share information due to sensitivity. There are a lot more columns in the spreadsheet im using such as. Activity Name, Duration, Project Name etc etc etc. but is roughly 24000 rows of information. Hopefully the screenshot of excel will give an indication of what im after. If not ill have to try a replicate the data wtih new data in BI as an example. 

       

       

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        6 years ago

        Anonymous 

        Try to create measures

        total activity = COUNTROWS('Table')

Total remaining = CALCULATE(COUNTROWS('Table'),FILTER(ALLEXCEPT('Table','Table'[Planner]),'Table'[Activity status]<>"Finished"))

Missing Logic = CALCULATE(COUNTROWS('Table'),FILTER(ALLEXCEPT('Table','Table'[Planner]),'Table'[Logic]="Missing Logic"&&'Table'[Activity status]<>"Finished"))

%not linked = [Missing Logic]/[Total remaining]

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Check this formula.

    Measure = 
var remain = COUNTX(FILTER('Table','Table'[activity status]<>"finished"),'Table'[planner])
var missing = COUNTX(FILTER('Table','Table'[activity status]<>"finished"&&'Table'[logic]="missing logic"),'Table'[planner])
return
missing/remain

    Result would be shown as below.

     

     

    Best Regards,

    Jay