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
pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Anonymous , 
Please try to use ALLSELECTED function .
For example :- 

AllSelected = CALCULATE(SUM(Orders[Sales]) ,ALLSELECTED(Orders[Product Category]))

Please refer to the link :-

https://learn.microsoft.com/en-us/dax/allselected-function-dax

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