Forum Discussion
Two Measures, Two almost equal IDs in both - How to show the IDs that not included in first Measure
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!
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.
1 Reply
- Greg_Deckler
Community Champion
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.