Develop existing Filter Code

[StuartSmith]

Happy New Year All, I have the below code that searches and filters a table column based on the selected value of another table and it works great, but need to develop it with more functionallity.

TEST_Search_SelectValue =
COUNTX (
FILTER ('Key Words', SEARCH ( [Value], SELECTEDVALUE ( 'Carrier Matrix'[OData__2_Contractcomments] ), 1, 0 ) > 0
),
1
)

Currently if there is no selected value, everything is filtered and the Carrier Matrix table visual is empty.  Is there a way so that if there is no selected value, no filter is applied and all rows in the "Carrier Matrix" table are displayed. I have tried something like...

TEST_Search_SelectValue =

IF(COUNTROWS('Key Words')=1, COUNTX(FILTER('Key Words', SEARCH ( [Value], SELECTEDVALUE ( 'Carrier Matrix'[OData__2_Contractcomments] ), 1, 0 ) > 0

),

1

))

and this filters if a Selected Value is present, but still displays an empty table if there no SelectedValue.  How can I fix this?  

Thanks in advance

[amitchandak]

@StuartSmith , Did not get it completely, You can use isfiltered to check if the value is filtered

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[StuartSmith]

Hopefully this explains it better...

[StuartSmith]

Just creating a demo file to upload.

[StuartSmith]

Find below a link to a demo file with explaination. Hope this helps.

Link: https://www.dropbox.com/s/h8eo788xhadhvmx/Test%20Key%20Word%20Search%20Buttons.pbix?dl=0

[StuartSmith]

ok, Got it working where it displays the full table, unless a button is pressed and then displays only the button related data.

Just need to add an "OR" statement so it searchs 2 columns for the results, but stumped on that for the moment.

[StuartSmith · Accepted solution]

Got it working with...

TEST_Search_SelectValue =

IF (

COUNTROWS ( 'Key Words' ) = 1,

COUNTX (

FILTER (

'Key Words',

SEARCH (

[Value],

SELECTEDVALUE ( 'Carrier Matrix'[OData__2_Contractcomments] ), 1, 0 ) > 0 || SEARCH ([Value],SELECTEDVALUE ( 'Carrier Matrix'[OData__8_Generalcomments] ), 1, 0 ) > 0

),

1

),

""

)