topic Re: Filter whole page with conditions from different tables in DAX Commands and Tips

Filter whole page with conditions from different tables

kitti — Mon, 19 Oct 2020 02:16:45 GMT

Hi experts,

I want to do filtering by conditions from different tables to the entire page of a power bi dashboard.

For example: I want to filter out Product A (table products) and Branch CT1 (table areas).

How do I do that? Please help.

Thanks

Re: Filter whole page with conditions from different tables

amitchandak — Mon, 19 Oct 2020 02:46:31 GMT

kitti , the filter can be applied on the table(dimensions) or the joined tables(Facts) . Depending on the relationship a "Slicer" or page level filters can be used

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Re: Filter whole page with conditions from different tables

kitti — Mon, 19 Oct 2020 03:53:18 GMT

Hi amitchandak ,

Thank you for your message.

I have a Product table and an Area table.

Product table:

product_id, product_name, ingredient, price

and Area table:

branch_id, branch_name, sales_zone, product_id

I want to do this filtering --> If product_name = 'A' then branch_name != 'CT1' (but for other products, will include branch_name CT1)

for all charts on the entire page.

Thanks,

Re: Filter whole page with conditions from different tables

amitchandak — Mon, 19 Oct 2020 05:54:58 GMT

kitti , if both tables have an active join on product id. It should work.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Filter whole page with conditions from different tables

kitti — Mon, 19 Oct 2020 08:40:22 GMT

Hi amitchandak ,

Sorry I cannot share the data. I tried using the filters pane with advanced filtering but it doesnt work. Can you please give some examples? Very similar to if-else condition I suppose.

Thanks,