topic Re: Flag multiple actions in same day in DAX Commands and Tips

Flag multiple actions in same day

mocha911 — Mon, 24 Jun 2024 05:25:54 GMT

Hi All,

I have tried to figure out this problem but have no success, hope someone can lend me their expertise in this problem. Thanks!

The problem-

If action "Sign Up" and (phone or email) happen in the same day, then show the flag for that member as 1, otherwise 0.

Data -

Client	Date	Action
A	1/01/2024	Phone
A	1/01/2024	Email
A	1/01/2024	Sign up
A	2/01/2024	Phone
B	1/01/2024	Sign up
B	2/01/2024	Phone
C	3/01/2024	Phone
C	3/01/2024	Email
C	4/01/2024	Sign Up

Expected result -

Result	have sign up and (email or phone) in same day
A	1
B	0
C	0

A has sign up and phone/email on same day.
B and C don't have the sign up in the same day as phone/email.

Thank you again in advance for all the assistance.

Re: Flag multiple actions in same day

Jihwan_Kim — Mon, 24 Jun 2024 05:43:30 GMT

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

It is for creating a measure.

expected result measure: = VAR _t = FILTER ( Data, Data[Action] = "Sign up" ) VAR _signupdatelist = SUMMARIZE ( FILTER ( Data, Data[Action] = "Sign up" ), Data[Date] ) VAR _condition = COUNTROWS ( FILTER ( Data, Data[Date] IN _signupdatelist && Data[Action] IN { "Phone", "Email" } ) ) > 0 RETURN IF ( _condition && HASONEVALUE ( Client[Client] ), 1, 0 )

Re: Flag multiple actions in same day

mocha911 — Mon, 24 Jun 2024 08:51:02 GMT

Thanks Jihwan_Kim !!!!!

You are a magician and life saver! Thank you so much. This works wonderfully.