Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Modify Dax measure to include multiple selected cities

Hi Experts   How can i change the following DAX measure so if i select mulitple cities on my slicers they are reflected in the title in the graph... Dynamic Title (Congestion) = VAR Result ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    worked it out 

    Dynamic Title (Congestion) =
    VAR Result = "Congestion Delay Index:"&" "&CONCATENATEX(DimCongestionCity,DimCongestionCity[City]," ,")
    Return
     Result
Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI pratyashasamal  this a title measure - not sure how i intergrate allselected into my measure???? based on slicer selection

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi Anonymous ,
So sorry i misunderstood .
Please try this once :-
For example :-

Multi_Months = CONCATENATEX ( VALUES ( financials[Month] ) , [Month] , ",")
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C