Forum Discussion
Super UserHow to apply additional filter on a visual
Hi anmolmalviya05 ,
Thanks for amitchandak's reply!
And anmolmalviya05 , you can try this:
Here is my sample data:You need to add another table with all 10 names in it:
Then use this DAX to create a measure:
Measure = IF( MAX('Table'[Name]) IN VALUES('#10'[#10]), 1, 0 )Make the settings as shown in the following figure:
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Useranmolmalviya05 , You can check if the preselected slicer can help. As of now, we can not default value of the slicer using measures
- anmolmalviya05
Hi amitchandak, Thanks for your reply,
I want to apply this using filter option in filter pane.
I have attached a screenshot for reference,Here I'm able to add only two values other than the value available in dataset. But i want to add 10 such values.
Approach I tried: First i selected all tha values available in dataset from basic filtering, then switched to advance filtering and replaced the existing name, but this is possible only for the number of names present in the data, i.e in this case i can only add 4 names, but i want to add upto 10 names.Hi anmolmalviya05 ,
Thanks for amitchandak's reply!
And anmolmalviya05 , you can try this:
Here is my sample data:You need to add another table with all 10 names in it:
Then use this DAX to create a measure:
Measure = IF( MAX('Table'[Name]) IN VALUES('#10'[#10]), 1, 0 )Make the settings as shown in the following figure:
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
