Filter based on Slicer selection

[lcasey]

Hello,

I am working on a financial report that must remove intercopmpany transactions. 

Intercomapny transactions are Identified as: Intercompany = IF('00-COA'[ACTNUMBR_5] = "9999" , "Yes","No")

Here is the logic:

1. IF there are no filters applied at all then remove all Intercompany transactions

2. IF "The Association" is selected in the ORG filter then show the transactions

I am strugling on how I can create a formula that filters out these transactiosn when nothing is selected and show these transactions when only the association is selected.

I have played with :  

Intercompany Filtered =
IF (
    HASONEVALUE ( '00-COASlicer'[Org2] ),
    VALUES ( '00-COASlicer'[Org2] ),
    "ALL"
)

Is there a way to select a slicer , then have the report automatically filter based on the selection?

I can Put a page level filter that would have a selection already made and as the slicer is used the page level filter should update.

[v-huizhn-msft]

Hi @lcasey,

Slicer is used to filter responding rows. If you relate it to a report, the report will change according to the selected value in slicer. If there is no choice in slicer, it will display all values.

>>1. IF there are no filters applied at all then remove all Intercompany transactions

Intercompany transactions are stored in table as rows level? It it is, we are unable to remove all Intercompany transactions when there are no filters applied using sclicer.

2. IF "The Association" is selected in the ORG filter then show the transactions.

You can crate a slicer including all ORG values.

If this is not what you want, could you please share your .pbix file for further analysis?

Best Regards,
Angelia