Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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())
@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())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |