Two Measures, Two almost equal IDs in both - How to show the IDs that not included in first Measure

[Anonymous]

Hello,

my first measure shows the full Table of IDs and my second measure is filtered and only show maybee 90% of ID-Values.

How can I detect the IDs in a third measure that is putting on my table, that shows the IDs that are not includet in the first measure? 

Thanks!

[Greg_Deckler · Accepted solution]

So, generally you would create 2 table variables that essentially replicate your visuals. Then you use EXCEPT.

If that is not specific enough, 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.