Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I am using Score Card to calculate rows counts as:
I have 5 files , below code is working good for 4 files correctly.
Thanks
Solved! 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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |