Conditional Calculated Column with Groupings

Question

Hello everyone, I am still new to DAX and I have a situation here that I've been looking to solve for a few days.

I have a table below and I am trying to populate Account_Status. The logic is bascially if the Unique_ID is same (group) and if any field in Product_Subscription is = 'Active' for this group, then Account_Status should be Active. How do I get this kind of output?

Thank you in advance!

Unique_ID	Product	Product_Subscription	Account_Status
100	P1	Active	Active
100	P1	Inactive	Active
100	P2	Inactive	Active
100	P3	Active	Active
200	P1	Inactive	Active
200	P2	Active	Active
200	P3	Inactive	Active
200	P3	Active	Active
200	P3	Active	Active
300	P2	Inactive	Inactive
300	P2	Inactive	Inactive

v-xuding-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
Please try like this:
&nbsp;
Account_Status =
VAR CountActive =
    CALCULATE (
        COUNTROWS( 'Table' ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[Unique_ID] ),
            'Table'[Product_Subscription] = "Active"
        )
    )
RETURN
    IF ( CountActive &gt; 0, "Active", "Inactive" )

&nbsp;

&nbsp;
&nbsp;

Forum Discussion

Conditional Calculated Column with Groupings

2 Replies

Related content

Conditional formatting on calculated item in calculation group

Conditional formatting using multiple calculation groups

Conditional grouping

Calculation Groups help

Condition Formating with Calculation group