SCORE CARD CALC.

[sdhn]

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.

UTRAlerts = COUNTROWS(ALLSELECTED(UTRAlerts))-1

this file has two rows but it is displaying 0.

Thanks 

[AlexisOlson]

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.

[sdhn]

Same out put

UTRAlerts = COUNTROWS( UTRAlerts ) -1

[AlexisOlson · Accepted 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.

[sdhn]

UTRAlerts = COUNTROWS ( ALL ( UTRAlerts )) - 1  - Worked ,  Thanks fo ryour help.