Help with Filtering a Table by Promotion Parameters in Power BI

[Matth_P]

Hi everyone,

I'm working on a Power BI report where I have two tables: Base and Promotions. The Base table includes sales, profitability, and cost data for all products by day and by branch, while the Promotions table includes similar data but only for products that are part of specific promotions. The tables are linked by the column LOCCOD-SKU-DATE, which is a concatenation of the columns LOCCOD (Branch code), SKU (Product code), and DATE.

I want to create a slicer to select a promotion (ProCod) from the Promotions table and have this filter the Base table to show only the relevant products and branches included in the selected promotion. I want to leave the date without filtering so users can compare those same products and branches in a time period where there was no promotion.

Thanks in advance for your help!

[v-yangliu-msft · Accepted solution]

Hi  @Matth_P ,

I created some data:

Base:

Promotions:

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTEDVALUE('Promotions'[ProCod])
var _date=SELECTCOLUMNS(FILTER(ALL('Promotions'),'Promotions'[ProCod]=_select),"date",'Promotions'[Date])
RETURN
IF(
    MAX('Base'[Date]) in _date,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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