Merge is too big - Cross table creation work around w/ slicers

[Anonymous]

These filters need to work across 3 datasets, into one table visualisation

The data sets are vast so trying to merge/join on key fields leads to load times that I have never seen the end of... spinning for 72 hours +

Is there anyway to populate the table with one dataset, then create measures that will if statement the results and return corresponding answers for columns within the other two datasets 

AKA

IF - Material Group = Z       Material Name = M       Prototype = N  then Duty Category Is = ? (Dataset 2)

[v-xiaotang]

Hi @Anonymous 

Have you solved this question? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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

[v-xiaotang]

Hi @Anonymous 

Now what I don't know is, what value do you want to return by doing an if judgment on the values in three different datasets? Which dataset do you want to get the value returned by measure? What relationship is it obtained by matching?

Please add more details into these 3 datasets, then give your expected result based on the sample you provide. Thanks.

Best Regards,

Community Support Team _Tang

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

[parry2k]

@Anonymous clear but still not fully sure. can you fake the data? I really don't care it is real or fake, but data and the expected output will help to understand the question better. 

[parry2k]

@Anonymous can you provide some sample data and explain what you are trying to achieve.

[Anonymous]

No Sample Data I'm afraid as classified

Let me try to explain a different way 

Dataset 1	Plant	Manu Type	Manu Plant	Territory
Dataset 2	Plant	Manu Type	Manu Plant	Duty	Batchcode
Dataset 3	Plant	Manu Type	Country	Commodity

With Merge & Left Join not working due to size of datasets

How can I make a table that IF statements matching keyfields that have slicers > eg. Plant A08 Selected

If Plant = A08   Dataset 1       Duty = Y   Dataset 2      Country = UK   Dataset 3 

So it queries other datasets rather than dynamically loading it into the table en mass