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.

     

VasTg's avatar
VasTg
Memorable Member
6 years ago

Anonymous 

 

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