Forum Discussion
Resolver IParameters 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'
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
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.
2 Replies
- lbendlin
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.
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 IsItFilteredBest Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
