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 )
Anonymous you cannot use slicer value in calculatetable, you need to create measure and use that in a table visual to show the data.
parry2k wrote:Anonymousyou cannot use slicer value in calculatetable, you need to create measure and use that in a table visual to show the data.
Hi Parry,
thanks for your reply.
Unfortunately I do not quite understand what you mean with creating a measure and using that in a table visual.
I just created a Measure that gives me the selected views, and tried using that as a filter instead - it didn't work either. Can you explain a bit more in depth?
Thank you for your help!
Leon
Anonymous it will be much easier to provide an answer if you post sample data with expected output.
parry2k wrote:Anonymousit will be much easier to provide an answer if you post sample data with expected output.
parry2k Thats a good Idea. So I have this table:
MIN VIEWS 100 150
200
250
and this table.
Product ID Views 1 500 2 300 3 450 4 30 5 20 My expected Output is a new table, that dependant on some form of selection tool, gives me this output:
Product ID Views 1 500 3 450 Thanks,
Leon
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 )