Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Compare two tables and display missing rows from the first table in a dynamic fashion

Hi Folks, I am a novice in power BI. I have two different tables that have hundreds of rows in them. The first table has live data i.e data changes every few seconds. The data in the second table ch...
Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Create a measure to check if the records exist in Table 2

    ExistInTable2 =  CONTAINS('TABLE - 2','TABLE - 2'[Name],MAX('TABLE - 1'[Name])) * 1

    Add the above measure to the Visual Filter of Table 1 and set to  = 0 and click apply. It will update automatically 

     

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     

     

  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    One way is to create a measure to use in the filter pane:

    Names Exclusive To table 1 = 
VAR Tab1 = VALUES(Table1[Name])
VAR TAb2 = VALUES(Table2[Name])
RETURN
COUNTROWS(EXCEPT(Tab1, TAb2))

    Add this measure to "Filters for this visual"  in the filter pane and set the value to 1

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Please find the attached file after the signature. the new table is create.

 

Measure like this

Measure = var _new = EXCEPT(ALL(Table1[Name]),all(Table2[Name])) return if( max(Table1[Name]) in _new,1,blank())

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak,

    The table you have created is working well when the data is stable in two tables. The measure, you have created displays the value 1. As the data in table-1 changes every few seconds, the table you have created is not considering the new rows that are being updated. We have to continuously compare the two tables and update the new table continuously. Do you have any kind of solution to this problem?