Forum Discussion
Creating a slicer from LOOKUPVALUE Range
Hello,
I'm trying to create a slicer from the LOOKUPVALUE Range measure, related to my earlier post from last week, which was answered.
Following up on that post, I'm trying to show which campaigns had an effective date, which did not, preferably on a slicer or on a pie chart. Unfortunately, creating a measure from the LOOKUPVALUE Range did not help and I could not achieve using ADDCOLUMNS and COUNTROWS as suggested by Greg_Deckler. My example dashboard is still available here on Dropbox and I'm happy to answer any questions.
Thanks,
Hi, Anonymous
If i understand what you mean, I think you only need to change the measure into a column, as I wrote above, so that you can use it at any time in the effective table.
Column = VAR __Score = 'Effective Date and Amount'[Effective Date] VAR __ID = 'Effective Date and Amount'[Location] return MAXX ( FILTER ( 'Campaign Levels', [Country Name] = __ID && __SCore >= [Campaing Start Date] && __Score <= [Campaign End Date] ), [Campaign Level] )Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi, Anonymous
I try to understand your needs, I think you need to create a column and then put it on the slicer to filter data.
Like this:
Column = VAR __Score = 'Effective Date and Amount'[Effective Date] VAR __ID = 'Effective Date and Amount'[Location] VAR __Scale = MAXX ( FILTER ( 'Campaign Levels', [Country Name] = __ID && __SCore >= [Campaing Start Date] && __Score <= [Campaign End Date] ), [Campaign Level] ) RETURN IF ( __Scale <> BLANK (), "has effective date", "no effective date" )If it doesn't solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many thanks v-janeyg-msft This is lovely. I realized I made a mistake in my original question. I'm actually trying to filter by the LOOUPVALUE Range measure. In other words, I want to create a slicer that separates blank LOOKUPVALUE Range with others, so that it shows whether there is a campaign level on that effective date or not. Apologies for the confusion.
Hi, Anonymous
This can be done, Can you use pictures or tables to show the results you want?
Best Regards
Janey Guo