how to Get number of element in a slicer to write a dynamic title ?

[AresBert]

Hi everyone, 

Im trying to create a title that is linked to a slicer.

In particular:
if one elements is selected in the slicer, than the title report the elements selected
if two or more elemtes are selected in the slicer, than the title report the lable "Multiple Selection"
If all elements are selected in the slicer, than the title report "All selected"

My problem is that i can't get the static number of elemets in the slicer to write my IF statement.
I've tried with COUNTROWS(MYTABLE), but once i select some item in the slicer, the rows selected are not correct.
How can i achieve this ?

[Ritaf1983 · Accepted solution]

Hi @AresBert 
you can create a measure like (with your original table and column names) :

test =

var counterSel = IF(ISFILTERED('Table'[County]), COUNTROWS(VALUES('Table'[County])),0)

var allSel =CALCULATE( DISTINCTCOUNT('Table'[County]),ALL('Table'[County]))

return

if (counterSel=allSel, "All sellected",

if (counterSel>1, "multiple sellected",

SELECTEDVALUE('Table'[County])))

Result :

Link to a sample file 

Please consider Accepting it as the solution to help the other members find it more quickly