Dynamic Title

Super User
2523 Views
Highlighted
Super User
Posts: 2,618
Registered: ‎11-29-2015

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!

Attachment