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 October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!