Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
3 years ago

Combine two in one -- counts

Hello All.
 
I have source & source 1 files.
Following code bring the counts of source files with extra one count.
 
Count = CALCULATE(COUNT(Source[Incident ID]) + COUNT('Source 1'[Parent PublicID]))
 
All red file has extra one in counts and belongs to source folder.
 
 I added -1 to first part of code with source folder as below:
Count = CALCULATE(COUNT(Source[Incident ID])-1) + COUNT('Source 1'[Parent PublicID])
 

Now all files count corrected under source folder but now one less counts on files under source 1 folder.

 

I can get corrcet values if separated source and source 1 in two different visual but i like ot have in one visual with corrcet counts. 

 

Your help will be appreciated.   Thanks 


 

 
 
 
Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    sdhn Long shot, but try this:

    Count = COUNT(Source[Incident ID]) + COUNT('Source 1'[Parent PublicID])
    • sdhn's avatar
      sdhn
      Responsive Resident
      3 years ago
      Count = COUNT(Source[Incident ID]) + COUNT('Source 1'[Parent PublicID])
       
      doing same as first result

       

      Added one in all counts of files under SOURCE.  Thanks