Forum Discussion
Return missing strings based on 2 conditions from two columns in the same table
Hi everyone, I was trying to solve this by looking for similar problems here but couldn't quite figure it out, some solutions involved creating a second table and use UNION/EXCEPT to show missing ent...
v-piga-msft
Resident Rockstar
Resident RockstarHi Anonymous,
It seems that you want to return the missing strings in one table.
However, it may be impossible to return the missing String without comparison in power bI currently. You should create another table to have a comparison to figure out the missing string.
You could create the temp table in a measure but it also have an effect for your calculation.
Best Regards,
Cherry
I use the matrix visual in the end and used count of type as value and count as column and string as rows. It at least lets me filter for those instances where a string is not occuring 13 times wihtout having to add any tables.