Forum Discussion

guyinazo's avatar
guyinazo
Helper I
5 years ago
Solved

CountIf using two related tables

So I have done some research but still need some help.  I have a main summary table that has Report ID numbers.  There is a separate Issues table that may or may not contain related Report IDs.  I ne...
Need Help
  • fhill's avatar
    fhill
    5 years ago

    How's something like this?  ** This assume NO relation between the tables, and even easier if there is a relation. **

     

    ** Add a New Column to your Summary Table as below:

    Has An Issue? =
    VAR Issue_Lookup = LOOKUPVALUE('Issues Table'[Report ID], 'Issues Table'[Report ID],'Summary Table'[Report ID])
    RETURN
    IF( ISBLANK( Issue_Lookup), BLANK(),1)
     

     


     

fhill's avatar
fhill
Resident Rockstar
5 years ago

How's something like this?  ** This assume NO relation between the tables, and even easier if there is a relation. **

 

** Add a New Column to your Summary Table as below:

Has An Issue? =
VAR Issue_Lookup = LOOKUPVALUE('Issues Table'[Report ID], 'Issues Table'[Report ID],'Summary Table'[Report ID])
RETURN
IF( ISBLANK( Issue_Lookup), BLANK(),1)
 

 


 

guyinazo's avatar
guyinazo
Helper I
5 years ago

Thanks, this works and is what I needed