list all items if category is "All" after Merge

[eliasayyy]

hello everyone i have a discount table and item table 

Discount : 

Items:

in items table, i dont have a All catgeory so when i merge the discount and items , i get inside the all category null 

how can i make it so it returns all the item ID

[eliasayyy · Accepted solution]

Step 1

After merging , expand your columns , 

Step 2 

add a new step i named it  allItemIDs

= List.Distinct(Items[Item ID])

step 3 

add a new custom column 

if [Item Category] = "All" then allItemIDs else { [Item ID] }

step 4 

expand to new rows

results