How to Use Slicer for Measure Values

[Anonymous]

Hello,

I am trying to have a slicer/chiclet slicer that will filter some values in my table. The #Aired values is a measure:

Show    # Aired

ABC          1

345           8

XYZ           6

I want to have a selection that is '1+' and '3+'. If i select '1+' that would be all the shows and if i select '3+' I can only see the last two shows. How can I set this up?

Thanks!

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Does that meet your requirement?

Measure = var a = MAX(Slicer[#Aired])
return
IF( a<=SUM('Table'[aired]),1,BLANK())

 

Pbix as attached.

[v-frfei-msft]

Hi @Anonymous ,

As we know, we cannot add measure to a slicer directly. We can use what if parameter to work on it. please refer to the following steps as below.

1. Create a what if parameter like this.

2. To create a measure and make the table  visual filtered by it.

Measure = IF([# Aired]>=Parameter[Parameter Value],1,BLANK())

For more details, please check the pbix as attached.

[Anonymous]

Thanks for your response. The challenge is we have a lot of data on shows and how many times they've aired. We only really need a view that splits it into '1+' and '3+'. Is it possible to get something like this?

So 1+ would show everything on the list and 3+ would show the last two as well as a show that aired exactly 3 times.

Thanks,

Quanita

[Syndicate_Admin · Accepted solution]

Hi @QuanitaA ,

Does that meet your requirement?

Measure = var a = MAX(Slicer[#Aired])
return
IF( a<=SUM('Table'[aired]),1,BLANK())

 

Pbix as attached.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Does that meet your requirement?

Measure = var a = MAX(Slicer[#Aired])
return
IF( a<=SUM('Table'[aired]),1,BLANK())

 

Pbix as attached.

[VasTg]

@Anonymous 

Why can't use expose the visual filter to the users to keyin the value with "is greater than or equal to" condition?