XLOOKUP Equivalent when working with Data Model (to return array of results)

I want to use some sort of lookup to return multiple results from a large table. The table I am referencing is more than 1 million rows, so I consolidate into a data model.

If I were using a regular table then this example XLOOKUP would give me what I want;

Formula:

Please Login or Register  to view this content.

This formula would then return 3 results in a Spill Array. (There is always only 1 result per lookup value)

I have only recently discovered the data model, so pretty fresh with it, but as I understand I need to use a CUBE function.

If I am only looking up 1 value then this formula works;

Formula:

Please Login or Register  to view this content.

But as soon as I try to expand the formula to lookup and return more than one result it does not work (Get #N/A result);

Formula:

Please Login or Register  to view this content.

Like I say I am pretty new to data models and cube functions so probably don't understand the capability fully.

Is there a way to edit above cube formula to return multiple results? Or perhaps a different method all together, any guidance gratefully received.

I do not attach an example workbook as imagine it will be pretty huge if I try to share data model.

This post relates to Windows Excel (not Mac).

Maybe you could solve this using Power Query.

Since there is nothing to test, I can't be certain about that.