Forum Discussion
Solved
Count across multiple columns
Hi everyone, Can someone help with this one please? If I have various columns of data in Excel and in Power-Bi I need a measure (or new column) that counts all the 'Outstanding' rows across the ...
try this
When I use this... it only shows the total as 4, when it should be 13
Measure =
COUNTROWS(
FILTER(
'IT Progress Data',
[202 Last Activitiy] = "Outstanding" && [203 Last Activitiy] = "Outstanding"
)
)