Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to Solution.
Hi @AresBert
you can create a measure like (with your original table and column names) :
Please consider Accepting it as the solution to help the other members find it more quickly
Hi @AresBert
you can create a measure like (with your original table and column names) :
Please consider Accepting it as the solution to help the other members find it more quickly