Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive 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. ...
"Need Help"
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    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.