Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI Chart for Project Status

Hi All I need a critical help. I tried alot to create a chart for Project status count based no of activities .I have a dummy data and output expected as below Project ID Task Name Activity Sta...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

You can try the following methods.

Column:

Project Status = 
Var _MaxComplete=CALCULATE(MAX('Table'[%Complete]),ALLEXCEPT('Table','Table'[Project ID]))
Var _MinComplete=CALCULATE(MIN('Table'[%Complete]),ALLEXCEPT('Table','Table'[Project ID]))
VAR _ResultComplete=IF(_MaxComplete=1,_MinComplete,IF(_MinComplete=0,_MaxComplete))
return
CALCULATE (
    MAX ( 'Table'[Activity Status] ),
    FILTER (
        ALL ( 'Table' ),
        [%Complete] = _ResultComplete
            && [Project ID] = EARLIER( 'Table'[Project ID] )
    )
)

Result:

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks alot for trying to help. But I have added two more tasks for Project ID5 as below, Where there are  2 Not Started and 1 complete, so still Project 5 to be considered in  Progress state. But in the table its reflecting as Not Started.