Need help: To add same description in two different tables

shakeelkhan 

To combine the information from the "REPLENISH" table with the "MATRIX TABLE" while filtering the "MATRIX TABLE" based on the quantity on a particular shop, you can use a calculated column or measure in Power BI. Below is an example of how you can achieve this using DAX measures:

1. **Create a Calculated Column in "REPLENISH" Table:**
This column will concatenate the "DESCRIPTION" and "COLOR" columns to create a unique identifier for each item.

```DAX
UniqueID = REPLENISH[DESCRIPTION] & "_" & REPLENISH[COLOR]
```

2. **Create a Measure in "MATRIX TABLE" to Filter Based on Quantity:**
This measure will calculate the sum of quantities for each description and color combination where the quantity is less than or equal to 5.

```DAX
TotalQty <= 5 =
CALCULATE(
SUM('MATRIX TABLE'[DESCRIPTION]),
FILTER('MATRIX TABLE', 'MATRIX TABLE'[DESCRIPTION] = SELECTEDVALUE('REPLENISH'[UniqueID]) && 'MATRIX TABLE'[STORES] <= 5)
)
```

3. **Add Description from "REPLENISH" Table to "MATRIX TABLE":**
Drag the "DESCRIPTION" column from the "REPLENISH" table to the "MATRIX TABLE" visualization to display the description alongside the quantities for each shop.

By following these steps, you can integrate the information from the "REPLENISH" table into the "MATRIX TABLE" while filtering the quantities based on the specified condition. This allows you to analyze the quantities carried by each shop for the items specified in the "REPLENISH" table.


Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!