Show Filter data with multiple column

[voonwah]

Hi All,

I'm new to PowerBI and currently working on a single dataset, would like to filter the result of user and the subscription.

The user are having multiple subscription in both contract, 

Can someone please advise how i can create a new column "duplicate" to show that if user is having duplicate subscription with value "YES" or"NO".

For example User1@email.com is duplicating his "subscription 1" in both contract, please help since this involving multiple column filtering.

Email Address	Department	Subscription	Contract
User1@email.com	Department A	Subcription 1	Contract A
User2@email.com	Department A	Subcription 2	Contract A
User1@email.com	Department B	Subcription 1	Contract B
User1@email.com	Department B	Subcription 3	Contract B

[voonwah]

@Samarth_18 Thanks and it works 🙂

[Samarth_18 · Accepted solution]

HI @voonwah ,

Create a column with below code:-

Column =
IF (
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[Email Address] = EARLIER ( 'Table'[Email Address] )
                && 'Table'[Subscription] = EARLIER ( 'Table'[Subscription] )
        )
    ) > 1,
    "Yes",
    "No"
)

Output:-

Thanks,

Samarth