Need to setup Power BI to work similar to XLOOKUP function with multiple criteria validation

[LT_Maverick]

I was able to develop an excel workbook using Xlookup multiple criteria function to pull information and populate it in the coordinating cells. 

How my Xlookup works:

Similar to the table below where I paste the data in the first four columns and XLOOKUP populates under the appropriate "WHSE" warehouse and the quantity that they show available, it leaves the cell blank if no qty is available. 

I want to be able to eliminate the copy and paste piece of this and be able to "select" which ever warehouse 1-6 and it list all products with a zero qty available and then populate in the coresponding cells the qty available in the other warehouses. 

And yes somtimes there will be things in one warehouse and not any other and that's okay. If I need to format/ clean my data in a different manner I am willing to do that. I just believe this functionality will help with overstock and product disruptions. Because I would like to use this in reverse as well. By looking at a WHSE that has no usage but lots of stock on hand, and I want to identify other warehouses that have a greater demand that will be able to use up the excess stock. 

I have the data loaded in Power BI, I just do not know how to format the visual. 

This is the formula I use in excel to pull the data and populate it in the workbook. 

This is how clean I would like it to look. 

WHSE (VARIABLE)	PRODUCT	QTY AVAIL	AVG USAGE	WHSE 1	WHSE 2	WHSE 3	WHSE 4	WHSE 5	WHSE 6
WHSE 6	10013076	0	7.8	1	1		18
WHSE 6	10015872	0	3.75			1		11
WHSE 6	10018536	0	34.16	3
WHSE 6	10023852	0	5.25			2		7
WHSE 6	10097762	0	21.5		5			2

[LT_Maverick]

TEST DATA For X Lookup Function to Power BI.xlsx

Test Data from Excel 

[lbendlin]

Your sample data doesn't seem to match your expected output.  Here's an example

where did the 13 disappear to?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...