Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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.
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |