Parameters in Title

[CEllis]

I have created a parameter to use as a filter to remove names when demostrating the application.

This works in charts or tables to display the actual name or the anonomised name but doesnt seem to work in the title.

I use the dax below in the title formula to dynamically change the title but it does nothing. 

If I use the actual fields without parameters the dax works ok.

The only thing I can think of is , is there a DAX statment for 'Show Values of Selected Field'

Paramter

Filter on all pages

Title change of visual using the dax below

DAX

Name = 
VAR ConCat =
    CALCULATE (
        CONCATENATEX (
            VALUES ( '-Anonymous Name'[Name] ),
            '-Anonymous Name'[Name] ,
            ", "
        )
    )
VAR IsItFiltered =
    IF ( ISFILTERED ( '-Anonymous Name'[Name]  ), ConCat, "ALL NAMES" )
RETURN
    IsItFiltered

[v-yangliu-msft]

Hi  @CEllis ,

You can try replacing '-anonymous' [name] with '-anonymous' [parameter field]

Name_measure =
VAR ConCat =
    CALCULATE (
        CONCATENATEX (
            VALUES ( 'Table'[Name]),
            'Table'[Name],
            ", "
        )
    )
VAR IsItFiltered =
    IF ( ISFILTERED('-Anonymous Name'[Parameter Fields]), ConCat, "ALL NAMES" )
RETURN
    IsItFiltered

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin · Accepted solution]

is there a DAX statment for 'Show Values of Selected Field'

Short answer is no.  Long answer is that you can collect the selected parameters and then harvest all the values from these parameters (assuming they are materialized), but there is no guarantee about the filter context.