Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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())
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |