Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
3 years ago

Combine two codes

Hello All,

 

I have two codes in report and working fine..

 

1) 

Count = COUNT(Source[Incident ID])+0
 
2) 
Count2 = COUNT('Source 1'[Parent PublicID])+0
 
I got resulst in two visuals.
 

 

Now I want to dispaly in one visual.
 
How can I combine both codes?  I will appreciate your help.  Thanks
 
 Cheers 

4 Replies

  • hi sdhn 

    you may just try like:

    Count = 
    COUNT(Source[Incident ID])+
     COUNT('Source 1'[Parent PublicID])+0
     
    in case of issue, please show
    1) how are the two tables related
    2) what context do you have for the expected measure, or how would you like to present the measure?
    • sdhn's avatar
      sdhn
      Responsive Resident

      All files exceed by total count of 1.  They all files belongs to same folder called Source.

      without + 0 is same results.

       

      If I do -1 

       

       

      Two files reduce by count 1.  Both belongs to SOURCE 1 folder.

       

  • Hi sdhn ,

     

    Are you looking a solution to display the total count for both combined in a card visual? 😎

    Many Thanks,

     

    Taylor

    • sdhn's avatar
      sdhn
      Responsive Resident

      yes,  on one visual