cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Title

Super User
3270 Views
Super User
Super User

Dynamic Title

Selected {category} =
VAR myTable = {table}
VAR myDelimter = ", "
VAR myThreshold = 3
VAR DelimiteredList1 = "," & CONCATENATEX({table},myDelimter & {category})
VAR DelimiteredList2 = SUBSTITUTE(DelimiteredList1,",, ","")
VAR ItemsSelected = COUNTROWS(MyTable)
VAR ReturnValue = SWITCH(
TRUE() ,
------------
ISFILTERED({category}) = false , "Nothing selected" ,
ItemsSelected > myThreshold , ItemsSelected & " items selected" ,
-- ELSE --
DelimiteredList2
)
RETURN ReturnValue


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!