Compare STRING Values over X Time

[PowerBIAccount]

Hello Everyone,

Sorry, I am kind of new to POWER BI and have a challenge where I failed so far finding a solution.

Basically I need to compare String values, in order to see if the users have touched their mails or not over the past x years.

I assume I’ll have to work with a measure, but both ROW and FILTER weren’t that helpful so far.

My data looks like:

Year	User12345	User987465	User54451
2017	Sent	Bounced	Clicked
2018	Opened	Sent	Clicked
2019	Clicked	Sent	Sent
2020	Sent	Sent	Sent

Has anyone another approach on how to filter all the users who never had “Opened” or “Clicked” in the past x years?

Sorry, if this is the incorrect place for this question. Perhaps I am overthinking this as well, and the solution is very easy.

Thanks for your help!

[amitchandak · Accepted solution]

@PowerBIAccount , first un pivot this data

https://radacad.com/pivot-and-unpivot-with-power-bi

and try measure

if(isblank(countrows(filter(Table, Table[Action] in {"Opened","Clicked"}))),1,blank())