cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## Show Selected Filter Value "ALL"

Hi,

I want to create a card to display the selected values of a slicer, I created a measure in this way:

Display Name =
IF(
ISFILTERED(field_1),
SELECTEDVALUE(field_1),
"ALL"
)

But when all the values in the filter are selected instead of "ALL" i get blank.

Do you why am I getting blank instead of "ALL" and how to solve it?

Thanks,
Andrea
1 ACCEPTED SOLUTION
Resolver I

I solved in this way:

IF( ISBLANK(IF(
ISFILTERED(field1),
SELECTEDVALUE(field1),
"All"
)),"All",SELECTEDVALUE(field1))

Hope it could helps other.

Thanks!
6 REPLIES 6
Super User

@arimoldi

SELECTEDVALUE has a second parameter to show if the value selected is more than one of nothing is selected. Use your measure as follows:

Display Name =    SELECTEDVALUE(field_1, "ALL" )

Did I answer your question? Mark my post as a solution! and hit thumbs up
Resolver I

Thanks,

now it correctly shows "ALL" when all the values of the filter are selected; do you how to use concatenatex to shows all the selected values of the filter (eg value1, value2)?

Thanks,

Andrea

Super User

@arimoldi

in that case, use the solution provided by @Daniel29195

Did I answer your question? Mark my post as a solution! and hit thumbs up
Resolver I

Thanks,

I tried but in this way I can see all the values without the "ALL" when all the values are selected:

IF(
ISFILTERED(num[delta]),
calculate(CONCATENATEX(DISTINCT(field1), field1, ", ")),
"All"
)
and with the Daniel solution with the SWITCH I get an error on few arguments

var rows_count =  countrows (all(field1))
var filtered_rows_count =  countrows( values(field1))

return
switch(
true(),
if (rows_count =  filtered_rows_count , "ALL",
concatenateX ( values(field1) , values(field1) , unichar(10))))

Do you have some suggestion?

Thanks,
Andrea

Resolver I

I solved in this way:

IF( ISBLANK(IF(
ISFILTERED(field1),
SELECTEDVALUE(field1),
"All"
)),"All",SELECTEDVALUE(field1))

Hope it could helps other.

Thanks!
Super User

use this measure :

measure

var rows_count =  countrows (all(table_name[field_1]))

var filtered_rows_count =  countrows( values(table_name[field_1]))

return

switch(

true(),

if rows_count =  filtered_rows_count , "ALL",

concatenateX ( values(table_name[field_1]) , values(table_name[field_1]) , unichar(10))

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.