Filters rows for a certain text and look for other rows that is similar from another column

[_AJY]

Hi, Sorry if the subject is confusing. So I have a table that looks like this

Email	Date	Result
User1	Jan-23	High
User1	Feb-23	Medium
User2	Jan-23	Medium
User2	Feb-23	Medium
User2	Mar-23	Low
User3	Mar-23	High
User4	Feb-23	Low
User5	Feb-23	High
User5	Mar-23	Low

and I want to create a calculated column that will get the date if that User has any "Low" result on the other month and leave it blank if there is no "Low" result on any of that user's record.

Email	Date	Result	New Calculated column
User1	Jan-23	High
User1	Feb-23	Medium
User2	Jan-23	Medium	Jan-23
User2	Feb-23	Medium	Feb-23
User2	Mar-23	Low	Mar-23
User3	Mar-23	High
User4	Feb-23	Low	Feb-23
User5	Feb-23	High	Feb-23
User5	Mar-23	Low	Mar-23

Still new to PowerBi so I've been having a hard time implementing this as filtering the "Low" results only would disregard the previous records that I need to show as well.

[barritown]

Hi @_AJY,

Here is one of the options how to solve your problem:

Here is the [DAX] code in the text format for convenience:

New Calculated Column = 
VAR CurrentUser = [Email]
VAR CountLow = COUNTX ( FILTER ( ALL ( data ), AND ( data[Email] = CurrentUser, data[Result] = "Low" ) ), data[Result] ) + 0
RETURN IF ( CountLow > 0, [Date], BLANK () )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian