Forum Discussion

rajeevs15's avatar
rajeevs15
Regular Visitor
2 years ago

Filtering value form two slicers

Hello,

 

I have a report with two slicer (RSM and RSM1) from the same column and one table which is showing sales by salesmen under RSM's. RSM slicer's interaction with the RSM1 is none. now client is asking to select different RSM from both the slicers and salesmen table should show sales for both different selected RSM in slicers but the salesmen table becomes blank.

 

Please find drive link to download  PBI file for better clarity.

https://drive.google.com/drive/folders/1D9UymArTfCu_K2kIffb-e12zIovYBdhH?usp=drive_link 

Regards,

Need Help

1 Reply

  • JohnnySaade's avatar
    JohnnySaade
    Helper I
    2 years ago

    I usually don't like to create measures based on so many REMOVEFILTERS. But I found a fix for your problem by doing the following: Create 2 tables with DISTINCT referencing your salesmen column (Table names: Filter 1 & Filter 2), put them in 2 seperate slicers on the page and replace the sales measure in your table with this measure (replace the table and column references to apply to your model):

    IF OR(

    CALCULATE (SELECTEDVALUE (Sales[Salesmen]), REMOVEFILTERS('Filter 2')) in ALLSELECTED('Filter 1' [Salesmen]), CALCULATE (SELECTEDVALUE (Sales[Salesmen]), REMOVEFILTERS('Filter 1')) in ALLSELECTED('Filter 2' [Salesmen])),

    CALCULATE (SUM(Sales [Amount ]), REMOVEFILTERS ('Filter 1' ),REMOVEFILTERS('Filter 2')) ,

    BLANK() )