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)
     

     


     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

guyinazo - You can get COUNTIF equivalent here: Excel to DAX Translation - Microsoft Power BI Community

 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

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.