Table Display

Hello,

We are creating a dashboard in Power BI and are having difficulty with a display request from our users.  I am hoping you can help with that because I don't know how to start this.

Our company receives shipments into warehouse 0002 and then transfer items to our other warehouses that need replenishment.  This dashboard is going to be used by a person in warehouse 0002 and help her determine which warehouse she needs to create a transfer to (specific to that ITEM).  

Our table consists of three columns:

ITEM – this is the item that may or may not need a transfer

WHSE – displays the warehouse number

WHSE QTY – shows the qty of that item.  If it is positive, we have inventory.  If it is negative, that warehouse is demanding inventory.

Here are some conditions that we are looking to satisfy for the development of this dashboard.

• In all cases, we never want to show a line for the ITEM at WHSE 0002.  We only want to display which WHSE that ITEM needs to be transferred to.

• If WHSE (0002) has a WHSE QTY that is equal to the demand to another warehouse for that ITEM then show ONLY the demanding warehouse.  If there is more than one demanding warehouse for that ITEM then we only need to display one WHSE (it doesn’t matter which demanding warehouse is displayed).  In the example below, WHSE 0002 can fill the demand for WHSE 0004 and 0030.  We only need to display one warehouse so we would like the output to only show the row in the middle.  We don’t need to see the first and third row.

• If WHSE (0002) has a WHSE QTY that is equal to zero or is negative for that ITEM, do not display an output for that ITEM (for any WHSE).  In the example below, WHSE 0002 does not have inventory to transfer so no need to display either row.

• If WHSE (0002) has a WHSE QTY that is positive for that ITEM AND the WHSE QTY at ALL of the other WHSE locations are positive for the same ITEM then do not display any of the results.   In the example below, all of the warehouses have a positive WHSE QTY and none of these rows need to be displayed.

• If WHSE (0002) does not have an ITEM listed, then do not show any rows for that ITEM.  In the below example, WHSE 0002 does not carry that item so it cannot help replenish the demand for that ITEM at the other WHSE's.

Here is some sample data, if helpful.  The examples above, appear here.  This community has been really great.  I've learned so much from here.  I hope to be as proficient at Power BI as all of you are soon so that I can give back and start helping others!