Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Use Slicer for Measure Values

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   ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Does that meet your requirement?

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

     

     

    Pbix as attached.

     

  • Syndicate_Admin's avatar
    Syndicate_Admin
    5 years ago

    Hi @QuanitaA ,

     

    Does that meet your requirement?

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

     Capture.PNG

     

    Pbix as attached.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Does that meet your requirement?

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

 

 

Pbix as attached.