Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |