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 %. ...
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

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