Forum Discussion
Filter Table based on Slicer Selection
Anonymous add measure as below and in table visual, drop product and this new measure, you will have solution
Views Total = VAR __selectedValue = SELECTEDVALUE( Table2[MinViews] ) RETURN CALCULATE( SUM( Table3[Views] ), Table3[Views] >= __selectedValue )
parry2k wrote:Anonymousadd measure as below and in table visual, drop product and this new measure, you will have solution
Views Total = VAR __selectedValue = SELECTEDVALUE( Table2[MinViews] ) RETURN CALCULATE( SUM( Table3[Views] ), Table3[Views] >= __selectedValue )
parry2k That works quite well, thank you. However when I add any other columns, new Products come into the table. Any chance I can prevent that? So then the output looks like this:
| Product ID | Views Total | Price |
| 1 | 500 | 50 |
| 2 | 60 | |
| 3 | 450 | 10 |
| 4 | 22 | |
| 5 | 12 |
I don't want 2,4,5 in the table though, because I'm working with and visualizing the numbers...
Thanks,
Leon
Anonymous in visual level filter, in measure , choose great than zero.
parry2k wrote:Anonymousin visual level filter, in measure , choose great than zero.
Thank you parry!!
Hi i have more or less the same problem.. https://community.powerbi.com/t5/DAX-Commands-and-Tips/FILTER-TABLE-BASED-ON-SELECTED-VALUE/m-p/1075696#M15087
But it doesnt work for me this solution.
Can you help ?
