Measure not updating to reflect that data is not filtered

[mossshvlw]

Hi all,

I have a filter set up on a report I'm making in Power Bi Desktop, that will filter data by county.  I also have a measure that made that will display in text the current value of the filter.  So, if "Jackson" is selected for county, it will display the text "Jackson".  Here's my syntax for the measure I've created:

Filters Selected =

IF (

ISFILTERED ( myTable[County] ),

CONCATENATEX ( FILTERS ( myTable[County] ), myTable[County], ", " ),

"ALL"

)

The measure works as expected when a specific county is selected:

The problem is that when no county is selected in the filter (i.e. it's set to "All"), the text still reads the name of a county (the first one in the alphabetical list is Adams, so it's likely just reading the first value?):

Can anyone tell me what I'm doing wrong here?  Thanks in advance.

[Icey]

Hi @mossshvlw ,

I can't reproduce, too. Please update your Power BI Desktop to the latest version and then try it again by following the steps provided by @PaulDBrown.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[PaulDBrown]

@mossshvlw 

I've just checked and it seems to work on my side (using a dummy dataset).

Using this measure on a card visual:

Selected Items or Display ALL =
IF (
    ISFILTERED ( 'Actuals1'[Item] ),
    CONCATENATEX ( FILTERS ( Actuals1[Item] ), Actuals1[Item], ", " ),
    "ALL"
)

And this measure for the title in the bar chart visual:

Selection Title = "Sum of Sales for " & [Selected Items or Display ALL]

If you are seeing the first value as the default in the title of a visual, you need to create a measure (see above) and add it to the conditional formatting under "Title" in the format pane: