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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

worked it out 

Dynamic Title (Congestion) =
VAR Result = "Congestion Delay Index:"&" "&CONCATENATEX(DimCongestionCity,DimCongestionCity[City]," ,")
Return
 Result