AGGREGATED COLUMN

[zahid_sabri]

Hi, 

I am not a pro in Power BI, but have some experience. Is there a way to calculate the status of column A to C based on status of column D? 

[bhanu_gautam]

Could you share sample output, what kind of output are looking exactly

[zahid_sabri]

basically i just want a status (count using card) for:

1. module

2. submodule

3. strategy

but all this are bind with the status of activity either done, ongoing or pending.

example:

1. for submodule 1.1, considered in done(green) because all the activity in this submodule > strategy is done.

2. for submodule 1.2, it is considered ongoing (yellow) because the status of one of its strategy is still ongoing, therefore this submodule is ongoing.

status for activity not a problem..but i cannot find a solution how to match the bigger scope (module/submodule/strategy) with the status of activity. 

[zahid_sabri]

for now, I already tried this for strategy completion but the result not showing as needed because it show completed activity within same strategy as not complete while if all activity in same strategy completed, it not showing the strategy as complete. I think if I can pull this one, for other status (Module & Submodule) will be the same right?

Strategy Completion = 
IF(
    COUNTROWS(FILTER('YourTable', 'YourTable'[Activity Status] = "Complete")) = COUNTROWS(FILTER('YourTable', 'YourTable'[Submodule] = EARLIER('YourTable'[Submodule]))),
    "Complete",
    "Not Complete"
)