Table Filtering issue

[kivancc94]

Hi,

I would be happy if you could help me. 

I have one filter and one table visuals. Even if i did not selected anything from slicer, it is still showing 1 in table because as you know in table it is already filtered. How can i solve that ?

It should only show 1 when i selected value from slicer. Otherwise it must show 0 in table. 

[johnyip]

Hi @kivancc94 , ISFILTERED() doesn't work in that way.

Do you want to show 1 for all records when you are not selecting all items in the slicer? If so, please try the following:

highlight w slicer = 
VAR Len_Country = PATHLENGTH(CONCATENATEX(DISTINCT(ALL('Table'[Country])),[Country],"|"))
VAR Len_SelectedCountry = PATHLENGTH(CONCATENATEX(DISTINCT(ALLSELECTED('Table'[Country])),[Country],"|"))
RETURN IF(Len_Country=Len_SelectedCountry,0,1)

[sevenhills]

https://www.enjoysharepoint.com/power-bi-get-selected-value-from-slicer/

https://community.powerbi.com/t5/Desktop/Get-slicer-selected-values-in-table/m-p/2281143

Try using "SELECTEDVALUE" or VALUES depending on your needs. Check the links for examples.