Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
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