Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CEllis
Resolver I
Resolver I

Parameters in Title

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'

CEllis_3-1709295708687.png

 

 

Paramter

CEllis_1-1709295322526.png

Filter on all pages

CEllis_2-1709295490922.png

Title change of visual using the dax below

CEllis_0-1709295245269.png

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

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @CEllis ,

 

You can try replacing '-anonymous' [name] with '-anonymous' [parameter field]vyangliumsft_0-1709525518083.png

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

vyangliumsft_1-1709525518088.png

 

 

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
Super User
Super User

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.