Forum Discussion
How to Use Slicer for Measure Values
Hi Anonymous ,
Does that meet your requirement?
Measure = var a = MAX(Slicer[#Aired]) return IF( a<=SUM('Table'[aired]),1,BLANK())Pbix as attached.
Hi @QuanitaA ,
Does that meet your requirement?
Measure = var a = MAX(Slicer[#Aired]) return IF( a<=SUM('Table'[aired]),1,BLANK())Pbix as attached.
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.
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
Hi Anonymous ,
Does that meet your requirement?
Measure = var a = MAX(Slicer[#Aired]) return IF( a<=SUM('Table'[aired]),1,BLANK())Pbix as attached.
Hi @QuanitaA ,
Does that meet your requirement?
Measure = var a = MAX(Slicer[#Aired]) return IF( a<=SUM('Table'[aired]),1,BLANK())Pbix as attached.