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:

Source =
CALCULATE (
    COUNTROWS ( VALUES ( Source[Source.Name] ) ),
    ALLEXCEPT ( Source, Source[Source.Name] )
)

 

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

It change to 

 

count fo all files  only one row count as below:  

 

 

With old code :

 

 

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    sdhn 

     

    Can you post sample data as text and expected output? or the PBIX file?


    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.
    4. Relation between your tables

    Appreciate your Kudos!!
    LinkedIn:www.linkedin.com/in/vahid-dm/