Urgent! Need Help with Filtering a Table with 2 Unrelated Slicers

[krmol21]

Hello community,

I'm trying to get my 2 product slicers, based on unrelated product tables DIM_PRODUCT and DIM_PRODUCT_2, to filter one product table and show both products and their Volume measure. Basically, I want Product B, coming from DIM_PRODUCT_2 and selected in the 2nd slicer, to show as a 2nd row in my table with its Volume measure: Volume = sum(FACT_VOLUMES[VOLUME]). Currently only Product A, coming from DIM_PRODUCT table, is showing:

Can you please help with with making both selected products show up in the table without creating any new relationships in the data model? I'm also attaching a screenshots of the model view and a link to the dashboard (sample version).

Thank you!!

[v-jianpeng-msft · Accepted solution]

Hi, @krmol21 

Have you already solved the current problem? To achieve this, you need to create a calculation table for both slicers as follows:

Slicer1Product = SUMMARIZE('DIM_PRODUCT',DIM_PRODUCT[PRODUCT])

Slicer2Product = SUMMARIZE('DIM_PRODUCT_2','DIM_PRODUCT_2'[product])

Put the two columns of these two tables into two slicers as follows:

Create a new measure using the following DAX expression:

tag = 
VAR _slicer1 = SELECTCOLUMNS('Slicer1Product','Slicer1Product'[PRODUCT])
VAR _slicer2 = SELECTCOLUMNS('Slicer2Product','Slicer2Product'[product])
RETURN IF(SELECTEDVALUE(DIM_PRODUCT[PRODUCT]) IN _slicer1 || SELECTEDVALUE(DIM_PRODUCT[PRODUCT]) IN _slicer2,1)

Place this measure on the visual filter panel and set it to a value of 1:

Here are the results:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[krmol21]

Hi @v-jianpeng-msft , thanks a lot for your suggested apporach, it does work, however, I was wondering if you know if there is a way to keep original DIM_PRODUCT[PRODUCT] and DIM_PRODUCT_2[product] fields in the slicers and make them work in the intended way?

The reason I'm asking is

1) I don't quite understand how the 2 summarized tables you created are different from the original DIM tables (why the intended filtering works only with your suggested approach)

2) I have other pages and measures that depend on these slicers, so changing the fields in the slicer means changing them across the whole dashboard, so want to check if you know a way to avoid using new fields in the slicers.

Thank you again!

[Shivu-2000]

Hi @krmol21,

Can you share us some sample data and report.

[krmol21]

Hi @Shivu-2000, I have attached a link to the sample report: https://drive.google.com/file/d/1lERA92omXsJ9CAIX01-vVRWVShAvMf5h/view?usp=sharing 

Thanks!