Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
4 years ago

Getting one extra count.

Hello All,   I have a measure as   OpenNMSCounts = COUNTROWS(ALLSELECTED(Source)) -1   I am getting one extra count.  For eg:   Totals Rows are "30" but its dispalys as: "31".  Any help wil...
Help
VahidDM's avatar
VahidDM
Super User
4 years ago

Hi sdhn 

 

Try this:

OpenNMSCounts = Distinct(ALLSELECTED(Source)) 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

  • sdhn's avatar
    sdhn
    Responsive Resident
    4 years ago

    Did not work out.  Error 

     

    screen grayed out