Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Example Table
Column 1 | Column 2 |
First | First |
Second | Second |
Third | Third |
Fourth | |
Fifth | Fifth |
Sixth | |
Eighth | Eighth |
So, what I am trying to do is Count all the cells in column 1 that are NOT blank AND match the adjacent cell in Column 2.
In this case, the total count should be 5. I use SumProduct in Excel to achieve this, but I have no idea how to create this in Power BI as I am still a baby user.
Solved! Go to Solution.
@akeener1 , A measure like
countrows(filter(Table, not(isblank(Table[Column 1])) && not(isblank(Table[Column 2]))) )
@akeener1 , A measure like
countrows(filter(Table, not(isblank(Table[Column 1])) && not(isblank(Table[Column 2]))) )
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |