This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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