Blank Data is not showing when filtered for blanks

[maya13]

Hello,

I have two systems to compare if employees were setup in the second system. Employee No comes from primary system and No_ comes from secondary system. There is a relationships between Employee No and No_. I created a simple visual to show blanks from secondary system but once I filter the visual to show only blanks for 'No_" it only shows the blank on Employee No. I have the 'show items with no data' ticked so I really do not know where the problem is.

Filtered by only Blanks on No_

[v-deddai1-msft · Accepted solution]

Hi @maya13 , 

Are you trying to show value that not in first system but in second system? You can follow the sample data:

Table1:

Table2:

Then you can create a measure to filter data from table2:

Measure = IF(MAX(Table2[Column1]) IN EXCEPT(VALUES(Table2[Column1]),VALUES('Table'[Column1])),1,0)

For more details, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EYoF5wTjS4tFloU4Tk...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@maya13 , difficult to say without looking at Data. Can you share a sample pbix after removing sensitive data.

[AlB]

Hi @maya13 

Can you share the pbix (or a mock version that reproes the issue)?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers