Using a lookup table to filter a fact table

That is exactly what I was looking for. I was trying to make a virtual table only with ADDCOLUMNS without the first step (vTable) u made and that obviously didn’t work out.

I am not yet familiar with the GENERATE function (amongst many other :woozy_face:), so this adds a lot to some my PBI knowledge and will help a lot with some reports I’m trying to make in PBI.
Thanks a bunch for your help Melissa!

Peter