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.
Go to Solution.
@akeener1 , A measure like
countrows(filter(Table, not(isblank(Table[Column 1])) && not(isblank(Table[Column 2]))) )
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.