https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Dynamic-Title/m-p/196974#M22 <P>Selected {category} = <BR />VAR myTable = {table}<BR />VAR myDelimter = ", "<BR />VAR myThreshold = 3<BR />VAR DelimiteredList1 = "," &amp; CONCATENATEX({table},myDelimter &amp; {category})<BR />VAR DelimiteredList2 = SUBSTITUTE(DelimiteredList1,",, ","")<BR />VAR ItemsSelected = COUNTROWS(MyTable)<BR />VAR ReturnValue = SWITCH(<BR /> TRUE() ,<BR /> ------------<BR /> ISFILTERED({category}) = false , "Nothing selected" ,<BR /> ItemsSelected &gt; myThreshold , ItemsSelected &amp; " items selected" ,<BR /> -- ELSE --<BR /> DelimiteredList2<BR /> )<BR />RETURN ReturnValue</P> <P><SPAN class="reportid hidden">eyJrIjoiZjIwNDg2MmItYTFlZS00N2Q5LTk1MTAtZWZmMDc3Y2Y1NDM4IiwidCI6ImNlZmU0NzBiLTVkMDItNGMwOS1iY2ViLWYzOGZkMmZmOWUyZSJ9</SPAN></P> Mon, 19 Jun 2017 21:46:15 GMT Phil_Seamark 2017-06-19T21:46:15Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Dynamic-Title/m-p/196974#M22 <P>Selected {category} = <BR />VAR myTable = {table}<BR />VAR myDelimter = ", "<BR />VAR myThreshold = 3<BR />VAR DelimiteredList1 = "," &amp; CONCATENATEX({table},myDelimter &amp; {category})<BR />VAR DelimiteredList2 = SUBSTITUTE(DelimiteredList1,",, ","")<BR />VAR ItemsSelected = COUNTROWS(MyTable)<BR />VAR ReturnValue = SWITCH(<BR /> TRUE() ,<BR /> ------------<BR /> ISFILTERED({category}) = false , "Nothing selected" ,<BR /> ItemsSelected &gt; myThreshold , ItemsSelected &amp; " items selected" ,<BR /> -- ELSE --<BR /> DelimiteredList2<BR /> )<BR />RETURN ReturnValue</P> <P><SPAN class="reportid hidden">eyJrIjoiZjIwNDg2MmItYTFlZS00N2Q5LTk1MTAtZWZmMDc3Y2Y1NDM4IiwidCI6ImNlZmU0NzBiLTVkMDItNGMwOS1iY2ViLWYzOGZkMmZmOWUyZSJ9</SPAN></P> Mon, 19 Jun 2017 21:46:15 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Dynamic-Title/m-p/196974#M22 Phil_Seamark 2017-06-19T21:46:15Z