Subtract 1 from output

[sdhn]

Hello All,

I have a measure as below:

OpenNMSCounts = COUNTROWS(ALLSELECTED(ONMSAlerts))

 This give me total row counts including column names.

I want to subtract 1 from the total counts. Above query subtract -1.

any help will be appreciated.

 thanks 

[smpa01 · Accepted solution]

@sdhn  do you mean this

OpenNMSCounts = COUNTROWS(ALLSELECTED(ONMSAlerts))-1