topic Re: AGGREGATED COLUMN in DAX Commands and Tips

AGGREGATED COLUMN

zahid_sabri — Tue, 30 Apr 2024 08:23:17 GMT

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?

Re: AGGREGATED COLUMN

bhanu_gautam — Tue, 30 Apr 2024 09:55:36 GMT

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

Re: AGGREGATED COLUMN

zahid_sabri — Thu, 02 May 2024 01:44:01 GMT

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.

Re: AGGREGATED COLUMN

zahid_sabri — Thu, 02 May 2024 04:38:48 GMT

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"
)