Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
eyJrIjoiZjIwNDg2MmItYTFlZS00N2Q5LTk1MTAtZWZmMDc3Y2Y1NDM4IiwidCI6ImNlZmU0NzBiLTVkMDItNGMwOS1iY2ViLWYzOGZkMmZmOWUyZSJ9