I am using Score Card to calculate rows counts as:
I have 5 files , below code is working good for 4 files correctly.
Go to Solution.
The most likely reason is that the table is filtered. Try hovering over the filter icon to see if this is the case.
You can also check if COUNTROWS ( ALL ( UTRAlerts ) ) - 1 is any different. If this also returns 0, then your table really only does have one row.
View solution in original post
ALLSELECTED is a complicated function. I'd recommend eliminating it entirely in this case unless there is some reason you need it (please explain if this is the case):
UTRAlerts = COUNTROWS ( UTRAlerts ) - 1
This will take into account slicers and filters, so I think it should behave as you were expecting the version with ALLSELECTED to.
Same out put
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!