What is a return of selectedvalue if none is selected but the slicer is showing all?

[Anonymous]

Hello!

I have 17 regions in the Region column and I need to create a table with dynamic names. For slicer I have activated "Multiple Choice with CTRL", it means that If nothing is selected, the values will be shown for all regions. Here comes my question: How can I write in DAX, if nothing selected my table name is: Entire country, otherwise region names from the slicer.

so far I tried:

IF((SELECTEDVALUE('Region')), "Entire country", SELECTEDVALUE('Region')))

[NidhiBhusari]

@Anonymous Do you want to Dynamically change the Heading  as per the selection from slicer? If Yes,then you can try below dax:_

Text = IF(ISFILTERED('TableName'[ColumnName]), SELECTEDVALUE('TableName'[ColumnName]),"Entire Countries")

[Anonymous]

In my slicer options are selected with CTRL, if there is no selection it shows "ALL". with your dax equation the result empty if i do not select region, but if I select it works. So I want, if slicer shows me "ALL" I want to see "Entire country" name on my table, otherwise selected region names.

[NidhiBhusari]

@Anonymous I have implemented same scenario, I have used Genre related dataset.

for me it is working...can you share your .pbix file?

[ara0530]

for me is not

[FrankAT]

Hi @Anonymous ,

with a slicer, something is always selected! For the selection "Select all" there are two settings in the slicer (see figure). Combinations of the slicer selection can be executed with the CTRL key. If you want to get the selected values use the above measure CONCATENATEX(...).

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

Thanks for your reply. I got your idea, but I do not need all these city names, I want to have only one name. For example for your data: Germany.