Forum Discussion

gcanelon's avatar
gcanelon
Frequent Visitor
5 years ago

Help with Filter function

Hello, we are trying to provide companies particiating in public tenders a list of what competitors they should keep an eye on. For this we are using a public dataset that contains information on ten...
Need Help
gcanelon's avatar
gcanelon
Frequent Visitor
5 years ago

Hello Amit. We tried your approach but there must be something we are doing wrong. The forula we are using is this: 

 

newTable = 
VAR _tt =
    SUMMARIZE (
        FILTER ( ALL ( 'Table' ), [Provider] = selectedvalue(Provider[Provider] ) ),
        'Table'[Request Item]
    )
RETURN
    FILTER ( 'Table', [Request Item] IN _tt && [Status] = "Adjudicated" )

 

But the behavior is as you can see in this video. Any suggestions? 

 

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

gcanelon A table will never update based on slicer selection due to Power BI Order of Operations 

 

Please try doing this as a measure, not a table, then add it as a filter to your visual. 

 

If you are wanting to show providers that are not in the selected slicer, you will either need to create a new table of providers that is NOT RELATED to your fact table, or clear filters and reapply them as you want using a measure. 

 

This video uses the duplicated Dim table method, but you might be able to get your desired result with just a measure. 

https://youtu.be/n3Hp-eNqudw 

 

Can you please share the sample pbix via OneDrive or other link?