Advanced Iterators on >4 columns fields


#1

Hi all
Just a question on how to do this the most effective way.
Practising doing advanced Iterators on multiple fields, where each condition should always match.
But in the below case this does not work.

Ive attached the file. Before I am asked yes i have watched the advanced analytic series on iterating through table. Just want to know the best practices for doing it on multiple fields

01.EnterpriseDNA.Standard Template.pbix (596.8 KB)
.


#2

I think i have figured actually how to do this.
Seems like more advanced cocepts where your filtering on multiple fields I need to use virtual tables.

This is what i wanted.